DBA Data[Home] [Help]

APPS.HRI_OPL_ACTLS dependencies on PAY_PAYROLL_ACTIONS

Line 161: pay_payroll_actions ppa

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
165: AND paa.assignment_id BETWEEN p_start_object_id and p_end_object_id;

Line 217: pay_payroll_actions ppa2,

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,
221: pay_element_types_f petf