APPS.POR_LOAD_EMPLOYEE_ASSIGNMENT dependencies on PER_ALL_PEOPLE_F
Line 242: SELECT person_id INTO l_supervisor_id FROM per_all_people_f
238: FUNCTION get_supervisor_id(x_supervisor_emp_num IN VARCHAR2) RETURN NUMBER IS
239: l_supervisor_id NUMBER;
240: BEGIN
241: 242: SELECT person_id INTO l_supervisor_id FROM per_all_people_f 243: WHERE employee_number = x_supervisor_emp_num;
244:
245: RETURN l_supervisor_id;
246: