APPS.PER_US_ETH_ORIG_MIG_PKG dependencies on PER_ALL_PEOPLE_F

Line 71: FROM per_all_people_f paf

67: ,paf.employee_number
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

Line 78: FROM per_all_people_f paf2

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
77: AND paf.effective_start_Date = (SELECT MAX(paf2.effective_start_date)
78: FROM per_all_people_f paf2
79: WHERE paf2.person_id = paf.person_id
80: AND trim(paf.per_information1) IS NOT NULL)
81: ORDER BY paf.business_group_id,paf.person_id;
82:

Line 341: FROM per_all_people_f paf

337: IS
338:
339: CURSOR c_get_ethnic_origin(p_object_id NUMBER) IS
340: SELECT paf.per_information1
341: FROM per_all_people_f paf
342: WHERE paf.person_id = p_object_id
343: AND paf.per_information1 IS NOT NULL;
344:
345: l_date_of_mig DATE;

Line 394: FROM per_all_people_f paf

390: ,paf.employee_number
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

Line 401: FROM per_all_people_f paf2

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
400: AND paf.effective_start_Date = (SELECT MAX(paf2.effective_start_date)
401: FROM per_all_people_f paf2
402: WHERE paf2.person_id = paf.person_id
403: AND trim(paf.per_information1) IS NOT NULL);
404:
405: /* cursor to check if the data already exists in the EIT*/