APPS.PAY_IN_EOY_REPORTS dependencies on PER_PERIODS_OF_SERVICE
Line 1844: per_periods_of_Service pps
1840:
1841: SELECT nvl(pps.actual_termination_date,paa.effective_end_Date)
1842: INTO l_asg_end_date
1843: FROM per_Assignments_f paa,-- Modified this for 4774108 to remove NMV 1844: per_periods_of_Service pps 1845: WHERE paa.assignment_id = l_assignment_id
1846: AND paa.period_of_service_id =pps.period_of_service_id
1847: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
1848: FROM per_all_assignments_f b