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_APAC_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 339: ,pay_run_results RR

335: IS
336: select distinct CONTEXT.result_value
337: from pay_run_result_values CONTEXT
338: ,pay_input_values_f PIVF
339: ,pay_run_results RR
340: ,pay_payroll_actions PACT,
341: pay_assignment_actions paa
342: where CONTEXT.run_result_id = RR.run_result_id
343: and CONTEXT.input_value_id = PIVF.input_value_id

Line 499: pay_run_results prr

495: p_input_value_id NUMBER)
496: IS
497: SELECT prv.result_value value
498: FROM pay_run_result_values prv,
499: pay_run_results prr
500: WHERE prr.status IN ('P','PA')
501: AND prv.run_result_id = prr.run_result_id
502: AND prr.assignment_action_id = p_assignment_action_id
503: AND prr.element_type_id = p_element_type_id

Line 515: pay_run_results prr

511: p_input_value_id NUMBER)
512: IS
513: SELECT sum(fnd_number.canonical_to_number(prv.result_value)) value/*Bug 3228928*/
514: FROM pay_run_result_values prv,
515: pay_run_results prr
516: WHERE prr.status IN ('P','PA')
517: AND prv.run_result_id = prr.run_result_id
518: AND prr.assignment_action_id = p_assignment_action_id
519: AND prr.element_type_id = p_element_type_id