APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_RUN_RESULTS

Line 254: from pay_run_results prr1,

250: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) prev_hire_date
251: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) prev_leaving_date
252: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
253: ,decode(substr(pap.national_identifier,8,1),1,NULL,2,NULL,3,NULL,4,NULL,pap.country_of_birth) country_code
254: from pay_run_results prr1,
255: pay_run_results prr2,
256: pay_payroll_actions ppa,
257: pay_assignment_actions paa,
258: pay_element_types_f pet1,

Line 255: pay_run_results prr2,

251: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) prev_leaving_date
252: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
253: ,decode(substr(pap.national_identifier,8,1),1,NULL,2,NULL,3,NULL,4,NULL,pap.country_of_birth) country_code
254: from pay_run_results prr1,
255: pay_run_results prr2,
256: pay_payroll_actions ppa,
257: pay_assignment_actions paa,
258: pay_element_types_f pet1,
259: pay_element_types_f pet2,

Line 322: from pay_run_results prr1,

318: pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) ns_hire_date
319: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) ns_leaving_date
320: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) ns_prev_hire_date
321: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) ns_prev_leaving_date
322: from pay_run_results prr1,
323: pay_payroll_actions ppa,
324: pay_assignment_actions paa,
325: pay_element_types_f pet1,
326: pay_input_values_f piv1,