APPS.PAY_P45_PKG2 dependencies on PAY_RUN_RESULTS

Line 303: r2 PAY_RUN_RESULTS_N50)

299: --
300: CURSOR csr_max_run_result IS
301: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
302: pact PAY_PAYROLL_ACTIONS_PK,
303: r2 PAY_RUN_RESULTS_N50)
304: USE_NL(assact2, pact, r2) */
305: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
306: r2.run_result_id),17))
307: FROM pay_assignment_actions assact2,

Line 309: pay_run_results r2

305: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
306: r2.run_result_id),17))
307: FROM pay_assignment_actions assact2,
308: pay_payroll_actions pact,
309: pay_run_results r2
310: WHERE assact2.assignment_id = p_assignment_id
311: AND r2.element_type_id+0 = l_paye_element_id
312: AND r2.assignment_action_id = assact2.assignment_action_id
313: AND r2.status IN ('P', 'PA')