APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_KR_REPORT_PKG

Line 244: Bug 4442482: Sparse Matrix enhancement - Use function PAY_KR_REPORT_PKG.GET_RESULT_VALUE in SELECT to make

240:
241: /* Start of current employee details */
242:
243: /*
244: Bug 4442482: Sparse Matrix enhancement - Use function PAY_KR_REPORT_PKG.GET_RESULT_VALUE in SELECT to make
245: query return row even when any one of these run result values is non-existent (null).
246: */
247: cursor c_cemp_details
248: is

Line 253: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date

249: select
250: pap.last_name||first_name emp_name
251: ,pap.nationality nationality
252: ,pap.national_identifier ni
253: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
254: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
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

Line 254: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date

250: pap.last_name||first_name emp_name
251: ,pap.nationality nationality
252: ,pap.national_identifier ni
253: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
254: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
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

Line 255: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) prev_hire_date

251: ,pap.nationality nationality
252: ,pap.national_identifier ni
253: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
254: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
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,

Line 256: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) prev_leaving_date

252: ,pap.national_identifier ni
253: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
254: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
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,

Line 319: Bug 4442482: Sparse Matrix enhancement - Use function PAY_KR_REPORT_PKG.GET_RESULT_VALUE in SELECT

315: * date, Prev Employer Hire date and Prev Employer
316: * Leaving date of an employee.
317: *********************************************************/
318: /*
319: Bug 4442482: Sparse Matrix enhancement - Use function PAY_KR_REPORT_PKG.GET_RESULT_VALUE in SELECT
320: to make query return row even when any one of these run result values is non-existent
321: (null).
322: */
323:

Line 327: pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) ns_hire_date

323:
324: cursor c_emp_nonstat_details
325: is
326: select
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,

Line 328: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) ns_leaving_date

324: cursor c_emp_nonstat_details
325: is
326: select
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,

Line 329: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) ns_prev_hire_date

325: is
326: select
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,

Line 330: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) ns_prev_leaving_date

326: select
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,