SQL Query to Get Payslip Details

  SELECT ppa.date_earned,

         per.full_name,

         per.employee_number,

         pec.classification_name,

         NVL (pet.reporting_name, pet.element_name) component,

         piv.NAME,

         prrv.result_value,

         ptp.period_name

    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_element_classifications pec,

         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 pec.classification_id = pet.classification_id

         AND upper(piv.NAME) = 'PAY VALUE'

         AND per.employee_number = '3049'

         AND ptp.period_name LIKE '1 2013 Calendar Month'