eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_KR_REPORT_PKG

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

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

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

244: select
245: pap.last_name||first_name emp_name
246: ,pap.nationality nationality
247: ,pap.national_identifier ni
248: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
249: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
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

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

245: pap.last_name||first_name emp_name
246: ,pap.nationality nationality
247: ,pap.national_identifier ni
248: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
249: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
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

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

246: ,pap.nationality nationality
247: ,pap.national_identifier ni
248: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
249: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
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,

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

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

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

306: * date, Prev Employer Hire date and Prev Employer
307: * Leaving date of an employee.
308: *********************************************************/
309: /*
310: Bug 4442482: Sparse Matrix enhancement - Use function PAY_KR_REPORT_PKG.GET_RESULT_VALUE in SELECT
311: to make query return row even when any one of these run result values is non-existent
312: (null).
313: */
314:

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

314:
315: cursor c_emp_nonstat_details
316: is
317: select
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,

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

315: cursor c_emp_nonstat_details
316: is
317: select
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,

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

316: is
317: select
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,

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

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