DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PER_PERIODS_OF_SERVICE

Line 900: per_periods_of_Service pps

896:
897: SELECT nvl(pps.actual_termination_date,paa.effective_end_Date),payroll_id
898: INTO l_asg_end_date,l_payroll_id
899: FROM per_Assignments_f paa,-- Modified this for 4774108 to remove NMV
900: per_periods_of_Service pps
901: WHERE paa.assignment_id = l_assignment_id
902: AND paa.period_of_service_id =pps.period_of_service_id
903: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
904: FROM per_all_assignments_f b