429: FUNCTION GetSupervisorName(
430: p_employee_id IN NUMBER
431: ) RETURN VARCHAR2 IS
432: p_manager_id NUMBER;
433: p_manager_name PER_WORKFORCE_CURRENT_X.FULL_NAME%TYPE;
434: p_manager_org_id NUMBER;
435:
436: ------------------------------------------------------------------_
437: BEGIN
461: p_supervisor_name OUT NOCOPY VARCHAR2
462: )IS
463:
464: p_manager_id NUMBER;
465: p_manager_name PER_WORKFORCE_CURRENT_X.FULL_NAME%TYPE;
466: p_manager_org_id NUMBER;
467:
468: ------------------------------------------------------------------_
469: BEGIN