DBA Data[Home] [Help]

APPS.PO_EMPLOYEES_SV dependencies on PER_ALL_ASSIGNMENTS_F

Line 120: PER_ALL_ASSIGNMENTS_F A,

116: X_emp_name,
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'

Line 188: per_all_assignments_f a,

184: p.full_name,
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

Line 212: per_all_assignments_f a,

208: p.full_name,
209: a.set_of_books_id,
210: a.location_id
211: FROM per_people_f p,
212: per_all_assignments_f a,
213: per_periods_of_placement pp,
214: fnd_user fnd,
215: hr_operating_units org
216: WHERE a.person_id = p.person_id