APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 527: -- 115.3 15-Apr-2010 dduvvuri Added condition on pay_run_Results to

523: -- 115.0 30-JUN-2003 bramajey Initial Version --
524: -- 115.1 03-JUL-2003 bramajey Changed parameter list in cursor. --
525: -- 115.2 27-Sep-2005 snekkala Removed use of pay_element_entry --
526: -- values_f in the cursor csr_asg_absences --
527: -- 115.3 15-Apr-2010 dduvvuri Added condition on pay_run_Results to
528: -- pick up only Processed and Adjusted run results.
529: --------------------------------------------------------------------------
530:
531:

Line 552: ,pay_run_results prr

548: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
549: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
550: FROM pay_assignment_actions paa
551: ,pay_payroll_actions ppa
552: ,pay_run_results prr
553: ,pay_run_result_values prrv
554: ,per_time_periods ptp
555: ,pay_element_types_f pet
556: ,pay_input_values_f piv

Line 721: , pay_run_results prr

717: ,ppa.business_group_id
718: ) exchange_rate
719: FROM pay_payroll_actions ppa
720: , pay_assignment_actions paa
721: , pay_run_results prr
722: , pay_run_result_values prrv
723: , pay_input_values_f piv
724: , pay_element_types_f pet
725: , pay_element_types_f_tl petl