APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 647: ,pay_run_results prr

643: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
644: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
645: FROM pay_assignment_actions paa
646: ,pay_payroll_actions ppa
647: ,pay_run_results prr
648: ,pay_run_result_values prrv
649: ,per_time_periods ptp
650: ,pay_element_types_f pet
651: ,pay_input_values_f piv

Line 2523: FROM pay_run_results

2519: --Find the run result id
2520: CURSOR c_run_result_id(p_element_type_id NUMBER)
2521: IS
2522: SELECT run_result_id
2523: FROM pay_run_results
2524: WHERE assignment_action_id=p_assignment_action_id
2525: AND element_type_id=p_element_type_id;
2526:
2527: --Find the actual remarks

Line 3482: FROM pay_run_results

3478: --Find the run result id
3479: CURSOR c_run_result_id(p_element_type_id NUMBER)
3480: IS
3481: SELECT run_result_id
3482: FROM pay_run_results
3483: WHERE assignment_action_id = p_assignment_action_id
3484: AND element_type_id = p_element_type_id;
3485:
3486: --Find the actual Exemption Reason