Query to Find Employee Basic Salary

SQL Query To find Employee Basic Salary

SELECT   ppa.date_earned, per.full_name, per.employee_number,

         NVL (pet.reporting_name, pet.element_name), piv.NAME,

         prrv.result_value, ptp.period_name,PTP.START_DATE,PTP.END_DATE

    FROM pay_payroll_actions ppa,

         pay_assignment_actions pac,

         per_all_assignments_f ass,

         per_all_people_f per,

         pay_run_results prr,

         pay_element_types_f pet,

         pay_input_values_f piv,

         pay_run_result_values prrv,

         per_time_periods_v ptp

   WHERE ppa.payroll_action_id = pac.payroll_action_id

     AND pac.assignment_id = ass.assignment_id

     AND ass.effective_end_date = TO_DATE ('12/31/4712', 'MM/DD/RRRR')

     AND ass.person_id = per.person_id

     AND per.effective_end_date = TO_DATE ('12/31/4712', 'MM/DD/RRRR')

     AND pac.assignment_action_id = prr.assignment_action_id

     AND prr.element_type_id = pet.element_type_id

     AND prr.run_result_id = prrv.run_result_id

     AND pet.element_type_id = piv.element_type_id

     AND piv.input_value_id = prrv.input_value_id

     AND ppa.time_period_id = ptp.time_period_id

     AND pet.element_name = 'BASIC_SALARY'

     AND piv.NAME = 'Pay Value'     

     AND per.employee_number = '1501909'

     AND ptp.period_name like '09 1435 RAMADAN'

ORDER BY 1;