DBA Data[Home] [Help]

APPS.PO_EMPLOYEES_SV dependencies on PER_PEOPLE_F

Line 119: FROM PER_PEOPLE_F P,

115: INTO X_emp_id,
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'

Line 187: FROM per_people_f p,

183: FROM (SELECT p.person_id employee_id,
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

Line 211: FROM per_people_f p,

207: SELECT p.person_id employee_id,
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