DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on PER_PERIODS_OF_SERVICE

Line 45: ,per_periods_of_service pps

41: SELECT pap.per_information5
42: ,pps.adjusted_svc_date
43: FROM per_all_people_f pap
44: ,per_all_assignments_f paaf
45: ,per_periods_of_service pps
46: WHERE paaf.assignment_id = c_assignment_id
47: AND paaf.person_id = pap.person_id
48: AND pap.person_id = pps.person_id
49: AND paaf.period_of_service_id = pps.period_of_service_id