APPS.PER_US_ETH_ORIG_MIG_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 72: ,per_people_extra_info pei

68: ,paf.business_group_id
69: ,paf.last_name
70: ,paf.first_name
71: FROM per_all_people_f paf
72: ,per_people_extra_info pei
73: WHERE paf.person_id = pei.person_id(+)
74: AND pei.information_type(+) = 'PER_US_ADDL_ETHNIC_CAT'
75: AND trim(paf.per_information1) IS NOT NULL
76: AND paf.person_id = p_person_id

Line 86: FROM per_people_extra_info pei

82:
83: /* cursor to check if the data already exists in the EIT*/
84: CURSOR c_eit_exists(p_person_id NUMBER) IS
85: SELECT 'Y'
86: FROM per_people_extra_info pei
87: WHERE pei.person_id = p_person_id
88: AND pei.information_type = 'US_ETHNIC_ORIGIN';
89:
90: l_object_version_number NUMBER;

Line 395: ,per_people_extra_info pei

391: ,paf.business_group_id
392: ,paf.last_name
393: ,paf.first_name
394: FROM per_all_people_f paf
395: ,per_people_extra_info pei
396: WHERE paf.person_id = pei.person_id(+)
397: AND pei.information_type(+) = 'PER_US_ADDL_ETHNIC_CAT'
398: AND trim(paf.per_information1) IS NOT NULL
399: AND paf.person_id = p_person_id

Line 408: FROM per_people_extra_info pei

404:
405: /* cursor to check if the data already exists in the EIT*/
406: CURSOR c_del_extra_info(p_person_id NUMBER) IS
407: SELECT pei.person_extra_info_id, pei.object_version_number
408: FROM per_people_extra_info pei
409: WHERE pei.person_id = p_person_id
410: AND pei.information_type = 'US_ETHNIC_ORIGIN';
411:
412: l_object_version_number NUMBER;