APPS.PER_SUCC_MGMT_MIGRATION_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 8: FROM per_people_extra_info pei,

4: CURSOR csr_chk_eit (p_bg_id NUMBER) IS
5: SELECT 'Y'
6: FROM dual
7: WHERE EXISTS (SELECT 'x'
8: FROM per_people_extra_info pei,
9: per_all_people_f ppf
10: WHERE ppf.business_group_id = p_bg_id
11: AND ppf.person_id = pei.person_id
12: AND pei.information_type = 'PER_SUCCESSION_PLANNING');

Line 37: FROM per_people_extra_info pei,

33: SELECT rpad(lookup_code,30) LOOKUP_CODE, meaning
34: FROM hr_lookups h
35: WHERE lookup_type = 'PER_SUCC_PLAN_POTENTIAL'
36: AND lookup_code IN (SELECT distinct pei_information1
37: FROM per_people_extra_info pei,
38: per_all_people_f ppf
39: WHERE pei.information_type = 'PER_SUCCESSION_PLANNING'
40: AND pei.person_id = ppf.person_id
41: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Line 53: FROM per_people_extra_info pei,

49: SELECT rpad(lookup_code,30) LOOKUP_CODE, meaning
50: FROM hr_lookups h
51: WHERE lookup_type = 'PER_SUCC_PLAN_RISK_LEVEL'
52: AND lookup_code IN (SELECT distinct pei_information2
53: FROM per_people_extra_info pei,
54: per_all_people_f ppf
55: WHERE pei.information_type = 'PER_SUCCESSION_PLANNING'
56: AND pei.person_id = ppf.person_id
57: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Line 101: FROM per_people_extra_info pei

97: ,pei.person_extra_info_id
98: ,pei_information3 --- key person
99: ,pei_information1 --- potential
100: ,pei_information2 --- risk of loss
101: FROM per_people_extra_info pei
102: ,per_all_people_f ppf
103: WHERE ppf.business_group_id = p_bg_id
104: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
105: AND ppf.person_id = pei.person_id

Line 108: FROM per_people_extra_info new

104: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
105: AND ppf.person_id = pei.person_id
106: AND pei.information_type = 'PER_SUCCESSION_PLANNING'
107: AND NOT EXISTS (SELECT 'x'
108: FROM per_people_extra_info new
109: WHERE new.information_type = 'PER_SUCCESSION_MGMT_INFO'
110: AND new.person_id = pei.person_id
111: AND new.pei_information7 = (-1*pei.person_extra_info_id));
112: l_ovn NUMBER;