APPS.PAY_P45_PKG2 dependencies on PAY_PAYROLL_ACTIONS

Line 302: pact PAY_PAYROLL_ACTIONS_PK,

298: AND input_value_id = p_ipv_id;
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))

Line 308: pay_payroll_actions pact,

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,
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

Line 322: pay_payroll_actions pact3

318: AND NOT EXISTS(
319: SELECT '1'
320: FROM pay_action_interlocks pai,
321: pay_assignment_actions assact3,
322: pay_payroll_actions pact3
323: WHERE pai.locked_action_id = assact2.assignment_action_id
324: AND pai.locking_action_id = assact3.assignment_action_id
325: AND pact3.payroll_action_id = assact3.payroll_action_id
326: AND pact3.action_type = 'V'