DBA Data[Home] [Help]

APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 1049: FROM per_all_people_f

1045: END IF;
1046:
1047: SELECT full_name, business_group_id
1048: INTO hxt_otc_retrieval_interface.g_full_name, l_bg_id
1049: FROM per_all_people_f
1050: WHERE person_id = l_person_id
1051: AND l_effective_date BETWEEN effective_start_date
1052: AND effective_end_date;
1053: EXCEPTION

Line 2322: FROM per_all_people_f

2318:
2319: BEGIN
2320: SELECT full_name, business_group_id
2321: INTO g_full_name, l_bg_id
2322: FROM per_all_people_f
2323: WHERE person_id = l_person_id
2324: AND l_effective_date BETWEEN effective_start_date
2325: AND effective_end_date;
2326: EXCEPTION