APPS.PAY_CONSUMED_ENTRY dependencies on PAY_PAYROLL_ACTIONS

Line 41: SELECT /*+ INDEX(PPA PAY_PAYROLL_ACTIONS_PK)*/

37: if g_debug then
38: hr_utility.set_location('consumed_entry', 20);
39: end if;
40: --
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,

Line 46: pay_payroll_actions PPA

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')
50: AND ASA.assignment_action_id = PRR.assignment_action_id