DBA Data[Home] [Help]

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