Function to get Employee full name by passing person id as parameter

CREATE OR REPLACE FUNCTION getemp (p1 IN NUMBER)
   RETURN VARCHAR2
AS
   v_emp   VARCHAR2 (50);
BEGIN
   SELECT full_name
     INTO v_emp
     FROM per_people_f
    WHERE person_id = p1
      AND current_employee_flag = 'Y'
      AND effective_end_date > SYSDATE;

   RETURN v_emp;
END;
/