APPS.HRI_OPL_ACTLS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 140: TYPE assignment_actions_tab IS TABLE OF pay_assignment_actions.assignment_action_id%TYPE;

136: PROCEDURE process_range(p_start_object_id IN NUMBER
137: ,p_end_object_id IN NUMBER )
138: IS
139: --
140: TYPE assignment_actions_tab IS TABLE OF pay_assignment_actions.assignment_action_id%TYPE;
141: l_assignment_actions assignment_actions_tab;
142: --
143: -- Variables to populate WHO Columns
144: --

Line 160: FROM pay_assignment_actions paa,

156: IF (g_full_refresh = 'Y') THEN
157: --
158: SELECT assignment_action_id
159: BULK COLLECT INTO l_assignment_actions
160: FROM pay_assignment_actions paa,
161: pay_payroll_actions ppa
162: WHERE paa.payroll_action_id = ppa.payroll_action_id
163: AND ppa.action_type IN ('C', 'S')
164: AND ppa.effective_date BETWEEN g_refresh_start_date AND g_refresh_end_date

Line 216: pay_assignment_actions paa2,

212: ,l_user_id
213: ,l_user_id
214: ,l_current_time
215: FROM per_all_assignments_f paaf,
216: pay_assignment_actions paa2,
217: pay_payroll_actions ppa2,
218: pay_run_results ppr,
219: pay_costs pc,
220: pay_input_values_f pivf,