APPS.CREATE_GB_RTI_EPS_RECORD_13 dependencies on PAY_PAYROLL_ACTIONS

Line 296: pay_payroll_actions pact

292: || paa.assignment_action_id),16)) lat_assignment_action_id,
293: MAX(pact.effective_date) effective_date,
294: paa.assignment_id
295: FROM pay_assignment_actions paa,
296: pay_payroll_actions pact
297: WHERE paa.payroll_action_id = pact.payroll_action_id
298: AND pact.action_type IN ('Q','R','B','I','V')
299: AND paa.action_status IN ('C','S')
300: AND pact.effective_date BETWEEN l_date_soy AND l_eff_start_date