APPS.PAY_CONSUMED_ENTRY dependencies on PAY_RUN_RESULTS

Line 44: FROM pay_run_results PRR,

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,
46: pay_payroll_actions PPA
47: WHERE PRR.source_id = p_ele_entry_id
48: AND PRR.source_type IN ('E', 'I')

Line 55: from pay_run_results prr2

51: AND PPA.payroll_action_id = ASA.payroll_action_id
52: --
53: -- Check whether the run_result has been revered.
54: AND not exists (select null
55: from pay_run_results prr2
56: where prr2.source_id = PRR.run_result_id
57: and prr2.source_type in ('R', 'V'))
58: AND PPA.date_earned BETWEEN l_period_start
59: AND l_period_end;