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

Pages

Tuesday, 10 May 2016

Query To find employee Salary details in oracle apps

SELECT   ppf.employee_number "EMPLOYEE NUMBER", ppp.change_date "FROM",
         ppp.date_to "TO",
           NVL (ppp.proposed_salary_n, 0)
         - (LAG (ppp.proposed_salary_n) OVER (ORDER BY ppp.change_date))
                                                              "CHANGE AMOUNT",
         ROUND
            (  (  (  NVL (ppp.proposed_salary_n, 0)
                   - (LAG (ppp.proposed_salary_n) OVER (ORDER BY ppp.change_date)
                     )
                  )
                / ppp.proposed_salary_n
               )
             * 100,
             2
            ) "CHANGE %",
         ppp.proposed_salary_n "SALARY",
         (ppp.proposed_salary_n * ppb.pay_annualization_factor
         ) "ANNUALIZED SALARY",
         pet.input_currency_code "CURRENCY", ppb.NAME "SALARY BASIS",
         ppp.approved "STATUS", ppp.pay_proposal_id
    FROM per_pay_proposals ppp,
         per_performance_reviews ppr,
         per_all_assignments_f paa,
         per_all_people_f ppf,
         per_pay_bases ppb,
         pay_input_values_f piv,
         pay_element_types_f pet
   WHERE 1 = 1
     AND ppp.performance_review_id = ppr.performance_review_id(+)
     AND paa.assignment_id = ppp.assignment_id
     AND paa.person_id = ppf.person_id
     AND ppp.change_date BETWEEN paa.effective_start_date
                             AND paa.effective_end_date
     AND paa.pay_basis_id = ppb.pay_basis_id(+)
     AND ppb.input_value_id = piv.input_value_id
     AND piv.element_type_id = pet.element_type_id
     AND ppp.change_date BETWEEN piv.effective_start_date
                             AND piv.effective_end_date
     AND ppp.change_date BETWEEN pet.effective_start_date
                             AND pet.effective_end_date
--AND PPF.EMPLOYEE_NUMBER = '30987'
--AND PAA.ASSIGNMENT_NUMBER   = '471-96-6472'
GROUP BY ppf.employee_number,
         ppp.change_date,
         ppp.date_to,
         NVL (ppp.proposed_salary_n, 0),
         ppp.proposed_salary_n,
         ppp.change_date,
         NVL (ppp.proposed_salary_n, 0),
         ppp.proposed_salary_n,
         (ppp.proposed_salary_n * ppb.pay_annualization_factor
         ),
         ppp.change_date,
         pet.input_currency_code,
         ppb.NAME,
         ppp.approved,
         ppp.pay_proposal_id

ORDER BY change_date DESC;
Share this article :

5 comments:

  1. My daughter earns R3500 a month now the boss has stock losses and deduct R2000 a month to value of R20 000 losses is this legal

    ReplyDelete
  2. I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Cloud Applications .Actually I was looking for the same information on internet for Oracle Cloud Applications Consultant and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  3. Thumbs up guys your doing a really good job. 相親香港

    ReplyDelete
  4. Engaging in an enterprise partnership has its own benefits. It allows all contributors to share with you the stakes within the business. click for more info

    ReplyDelete
  5. Admiring the time and effort you put into your blog and detailed information you offer!.. سلم الرواتب السعودي

    ReplyDelete