APPS.PO_EMPLOYEES_SV dependencies on HR_OPERATING_UNITS

Line 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

114: NVL(hr.LOCATION_ID,0)
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

Line 191: hr_operating_units org

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
194: AND a.assignment_type = 'E'
195: AND p.employee_number IS NOT NULL

Line 215: hr_operating_units org

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
217: AND a.person_id = pp.person_id
218: AND a.assignment_type = 'C'
219: AND p.npw_number IS NOT NULL