DBA Data[Home] [Help]

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: