APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_PEOPLE_F
Line 2451: FROM per_all_people_f
2447: --
2448: BEGIN
2449: SELECT full_name
2450: INTO g_full_name 2451: FROM per_all_people_f 2452: WHERE person_id = l_person_id
2453: AND l_effective_date BETWEEN effective_start_date
2454: AND effective_end_date;
2455: EXCEPTION