1071: END IF;
1072:
1073: SELECT full_name, business_group_id
1074: INTO hxt_otc_retrieval_interface.g_full_name, l_bg_id
1075: FROM per_all_people_f
1076: WHERE person_id = l_person_id
1077: AND l_effective_date BETWEEN effective_start_date
1078: AND effective_end_date;
1079: EXCEPTION
2392:
2393: BEGIN
2394: SELECT full_name, business_group_id
2395: INTO g_full_name, l_bg_id
2396: FROM per_all_people_f
2397: WHERE person_id = l_person_id
2398: AND l_effective_date BETWEEN effective_start_date
2399: AND effective_end_date;
2400: EXCEPTION