DBA Data[Home] [Help]

APPS.PAY_IE_LE_MIGRATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 202: per_all_assignments_f asg

198: SELECT distinct paa.*,ppa.action_type action_type,ppa.effective_date effective_date,
199: ppa.report_type,ppa.report_qualifier,asg.person_id person_id
200: FROM pay_assignment_actions paa,
201: pay_payroll_actions ppa,
202: per_all_assignments_f asg
203: WHERE paa.payroll_action_id = ppa.payroll_action_id
204: AND paa.action_status IN ('C','S') --10225372
205: AND ppa.effective_date between p_start_date and p_end_date
206: AND paa.assignment_id = asg.assignment_id