188: --
189: BEGIN
190: SELECT employee_number, full_name
191: INTO l_employee_number, l_full_name
192: FROM per_people_f
193: WHERE person_id = p_person_id
194: AND p_effective_date BETWEEN effective_start_date
195: AND effective_end_date;
196: EXCEPTION