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


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,
    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
ORDER BY papf.full_name;
Share this article :


  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,

  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!


  3. It is just a significant ordinary practice for organizations to decide on a structure which they can depend to provide precise outcomes reliably, as it makes the experience of the bookkeeping work force simpler. Probably the most basic part of a good pay stubs online is so it ought to provide precise data, in an easy to peruse way. 

  4. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  5. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work! pay weekly flooring

  6. Bayzat is the one of the best work life HR software that unifies HR, Payroll, and employee management in Dubai, UAE. payroll system

  7. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. Payroll Software in India

  8. Very nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks!. كم راتب