DBA Data[Home] [Help]

APPS.PAY_CN_AUDIT_XMLGEN dependencies on PER_PERIODS_OF_SERVICE

Line 177: per_periods_of_service pos

173: CURSOR csr_assignments IS
174: SELECT paf.assignment_id
175: FROM per_people_f ppf,
176: per_assignments_f paf,
177: per_periods_of_service pos
178: WHERE ppf.business_group_id = paf.business_group_id
179: AND pos.period_of_service_id = paf.period_of_service_id
180: AND paf.person_id =ppf.person_id
181: AND paf.person_id BETWEEN p_stperson AND p_endperson