根据员工编号提取员工信息

FUNCTION get_person_name (p_user_id IN NUMBER)
      RETURN VARCHAR2
   IS
      v_person_name   VARCHAR2 (100);
   BEGIN
      SELECT ppf.full_name
        INTO v_person_name
        FROM fnd_user fu, per_people_f ppf
       WHERE fu.employee_id = ppf.person_id(+) AND fu.user_id = p_user_id;

      RETURN (v_person_name);
   EXCEPTION
      WHEN OTHERS
      THEN
         RETURN (v_person_name);
   END;