DBA Data[Home] [Help]

APPS.PO_EMPLOYEES_SV dependencies on PER_PERIODS_OF_SERVICE

Line 121: PER_PERIODS_OF_SERVICE B

117: X_location_id
118: FROM FND_USER FND, hr_operating_units org, (SELECT p.person_id employee_id, p.full_name, a.SET_OF_BOOKS_ID , a.location_id
119: FROM PER_PEOPLE_F P,
120: PER_ALL_ASSIGNMENTS_F A,
121: PER_PERIODS_OF_SERVICE B
122: WHERE A.PERSON_ID = P.PERSON_ID
123: --AND A.PRIMARY_FLAG = 'Y'
124: AND A.ASSIGNMENT_TYPE = 'E'
125: AND A.PERIOD_OF_SERVICE_ID = B.PERIOD_OF_SERVICE_ID

Line 189: per_periods_of_service ps,

185: a.set_of_books_id,
186: a.location_id
187: FROM per_people_f p,
188: per_all_assignments_f a,
189: per_periods_of_service ps,
190: fnd_user fnd,
191: hr_operating_units org
192: WHERE a.person_id = p.person_id
193: AND a.person_id = ps.person_id