APPS.PAY_IN_TAX_UTILS dependencies on PER_PERIODS_OF_SERVICE

Line 1219: per_periods_of_service SERVICE

1215: -- Get the termination date of the employee
1216: SELECT SERVICE.actual_termination_date
1217: INTO l_terminate_date
1218: FROM per_assignments_f ASSIGN,
1219: per_periods_of_service SERVICE
1220: WHERE p_effective_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
1221: AND ASSIGN.assignment_id = l_assignment_id
1222: AND SERVICE.period_of_Service_id = ASSIGN.period_of_service_id;
1223:

Line 1227: per_periods_of_Service pps

1223:
1224: SELECT nvl(pps.actual_termination_date,paa.effective_end_Date),payroll_id
1225: INTO l_asg_end_date,l_payroll_id
1226: FROM per_Assignments_f paa,-- Modified this for 4774108 to remove NMV
1227: per_periods_of_Service pps
1228: WHERE paa.assignment_id = l_assignment_id
1229: AND paa.period_of_service_id =pps.period_of_service_id
1230: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
1231: FROM per_all_assignments_f b

Line 3571: per_periods_of_service pos

3567: -- Start of Bug 11821281
3568: SELECT pep.per_information4 INTO l_pan
3569: FROM per_all_people_f pep,
3570: per_all_assignments_f asg,
3571: per_periods_of_service pos
3572: WHERE asg.assignment_id = p_assignment_id
3573: AND asg.person_id = pep.person_id
3574: AND pos.person_id = asg.person_id
3575: AND pos.period_of_service_id = asg.period_of_service_id

Line 3973: per_periods_of_service pos

3969: -- Start of Bug 11821281
3970: SELECT pep.per_information4 INTO l_pan
3971: FROM per_all_people_f pep,
3972: per_all_assignments_f asg,
3973: per_periods_of_service pos
3974: WHERE asg.assignment_id = p_assignment_id
3975: AND asg.person_id = pep.person_id
3976: AND pos.person_id = asg.person_id
3977: AND pos.period_of_service_id = asg.period_of_service_id