689: --
690: BEGIN
691: SELECT employee_number, full_name
692: INTO l_employee_number, l_full_name
693: FROM per_people_f
694: WHERE person_id = p_person_id
695: AND p_effective_date BETWEEN effective_start_date
696: AND effective_end_date;
697: EXCEPTION