DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_RUN_RESULTS

Line 259: from pay_run_results prr1,

255: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) prev_hire_date
256: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) prev_leaving_date
257: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
258: ,ft.territory_code country_code
259: from pay_run_results prr1,
260: pay_run_results prr2,
261: pay_payroll_actions ppa,
262: pay_assignment_actions paa,
263: pay_element_types_f pet1,

Line 260: pay_run_results prr2,

256: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) prev_leaving_date
257: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
258: ,ft.territory_code country_code
259: from pay_run_results prr1,
260: pay_run_results prr2,
261: pay_payroll_actions ppa,
262: pay_assignment_actions paa,
263: pay_element_types_f pet1,
264: pay_element_types_f pet2,

Line 331: from pay_run_results prr1,

327: pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) ns_hire_date
328: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) ns_leaving_date
329: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) ns_prev_hire_date
330: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) ns_prev_leaving_date
331: from pay_run_results prr1,
332: pay_payroll_actions ppa,
333: pay_assignment_actions paa,
334: pay_element_types_f pet1,
335: pay_input_values_f piv1,