APPS.DK_CONSUMED_ENTRY dependencies on PAY_PAYROLL_ACTIONS

Line 39: pay_payroll_actions PPA

35: SELECT DECODE(COUNT(PRR.run_result_id), 0, 'N', 'Y')
36: INTO v_consumed
37: FROM pay_run_results PRR,
38: pay_assignment_actions ASA,
39: pay_payroll_actions PPA
40: WHERE
41: ASA.assignment_id = p_asg_id
42: AND PRR.source_type IN ('E', 'I')
43: AND PRR.status in ('P', 'PA', 'R', 'O')

Line 105: pay_payroll_actions PPA

101: SELECT DECODE(COUNT(PRR.run_result_id), 0, 'N', 'Y')
102: INTO v_consumed
103: FROM pay_run_results PRR,
104: pay_assignment_actions ASA,
105: pay_payroll_actions PPA
106: WHERE PRR.source_id = p_ele_entry_id
107: AND PRR.source_type IN ('E', 'I')
108: AND PRR.status in ('P', 'PA', 'R', 'O')
109: AND ASA.assignment_action_id = PRR.assignment_action_id

Line 124: pay_payroll_actions PPA,

120: select DECODE(COUNT(PRR.run_result_id), 0, 'N', 'Y')
121: INTO v_consumed
122: FROM pay_run_results PRR,
123: pay_assignment_actions ASA,
124: pay_payroll_actions PPA,
125: pay_run_result_values PRVV
126: ,pay_input_values_f PIVF
127: ,pay_element_types_f PET
128: WHERE PRR.source_id = p_ele_entry_id