APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PER_PEOPLE_F
Line 192: FROM per_people_f
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