DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 2958: from per_assignments_f a,per_assignments_f b

2954: )
2955: AND as1.effective_end_date <> to_date('31-12-4712','DD-MM-YYYY')
2956: )
2957: AND (as1.payroll_id in (select b.payroll_id -- 5059862
2958: from per_assignments_f a,per_assignments_f b
2959: where a.payroll_id = l_payroll_id
2960: and a.person_id = b.person_id
2961: and a.period_of_Service_id = b.period_of_Service_id
2962: and a.period_of_Service_id = as1.period_of_Service_id -- 5758951