Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 11 May 2016

Employee Payroll Name And Pay Bases

SELECT   ppt.user_person_type person_type, papf.full_name employee_name,
         papf.employee_number employee_number, pap.payroll_name, ppb.NAME pay,
         ppb.pay_basis
    FROM per_all_people_f papf,
         per_all_assignments_f paaf,
         per_person_types_tl ppt,
         per_pay_bases ppb,
         pay_all_payrolls_f pap
   WHERE papf.person_id = paaf.person_id
     AND paaf.primary_flag = 'Y'
     AND papf.current_employee_flag = 'Y'
     AND papf.business_group_id = paaf.business_group_id
     AND papf.person_type_id = ppt.person_type_id
     AND paaf.pay_basis_id = ppb.pay_basis_id
     -- AND PAPF.EMPLOYEE_NUMBER = '30987'
     AND paaf.payroll_id = pap.payroll_id
     AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
                             AND papf.effective_end_date
     AND TRUNC (SYSDATE) BETWEEN pap.effective_start_date
                             AND pap.effective_end_date
     AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date
                             AND paaf.effective_end_date
--   AND PAPF.FULL_NAME LIKE 'A%'
ORDER BY papf.full_name;
Share this article :

2 comments:

  1. Hello Mate,

    In debt to you for making my learning on the Employee Payroll Name And Pay Bases area so hassle-free! I lay my faith on your writings.
    I am facing the below issue(Screen shot) with CREATE_JOB procedure. The issue is with CREDENTIAL_NAME attribute.

    More information on this:

    I tried to create the job for one of the predefined chain.

    why I am using CREDENTIAL_NAME attribute is, in one of the chain step I am calling LINUX script.

    I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.

    Many Thanks,
    Ashish

    ReplyDelete
  2. Hi There,

    This is indeed great! But I think perhaps you are generally referring Employee Payroll Name And Pay Bases which is getting unsustainable.

    Can anyone suggest on TEMP table concept. I have below requirement and I tried the below but I am getting error.

    select partyno into #tmptbl
    from partym --------- when I executed this I got ORA-00911: invalid character error.

    my requirement is :
    I need to execute 3 queries one by one and hold the result of the first query and second query to feed as input to 3rd query. at the end of the job I need to delete first query and second query result.

    It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
    Keep up the good work!

    Gracias,
    Preethi.

    ReplyDelete