DBA Data[Home] [Help]

APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 1075: FROM per_all_people_f

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

Line 2396: FROM per_all_people_f

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