APPS.PAY_CONSUMED_ENTRY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 45: pay_assignment_actions ASA,

41: SELECT /*+ INDEX(PPA PAY_PAYROLL_ACTIONS_PK)*/
42: DECODE(COUNT(PRR.run_result_id), 0, 'N', 'Y')
43: INTO v_consumed
44: FROM pay_run_results PRR,
45: pay_assignment_actions ASA,
46: pay_payroll_actions PPA
47: WHERE PRR.source_id = p_ele_entry_id
48: AND PRR.source_type IN ('E', 'I')
49: AND PRR.status in ('P', 'PA', 'R', 'O')