APPS.PER_FR_DISABILITY_UPG_PKG dependencies on PER_ALL_PEOPLE_F

Line 20: , per_all_people_f per1

16: pei.PEI_INFORMATION8,
17: pei.PEI_INFORMATION9,
18: pei.PERSON_EXTRA_INFO_ID
19: FROM per_people_extra_info pei
20: , per_all_people_f per1
21: WHERE pei.PEI_INFORMATION_CATEGORY = 'FR_DISABILITY'
22: AND pei.person_id = per1.person_id
23: AND per1.business_group_id = p_business_group_id
24: AND per1.effective_start_date = (select max(per2.effective_start_date)

Line 25: from per_all_people_f per2

21: WHERE pei.PEI_INFORMATION_CATEGORY = 'FR_DISABILITY'
22: AND pei.person_id = per1.person_id
23: AND per1.business_group_id = p_business_group_id
24: AND per1.effective_start_date = (select max(per2.effective_start_date)
25: from per_all_people_f per2
26: where per2.person_id = per1.person_id
27: and per2.business_group_id = p_business_group_id)
28: AND pei.PEI_INFORMATION30 IS NULL
29: order by per1.full_name;

Line 93: FROM per_all_people_f

89: l_record_status :=0;
90:
91: SELECT MIN(EFFECTIVE_START_DATE), MAX(effective_end_date)
92: INTO l_person_start_date, l_person_end_date
93: FROM per_all_people_f
94: WHERE person_id = l_disabled.person_id;
95:
96: /* Determine Start date for disability record */
97: IF l_disabled.PEI_INFORMATION6 IS NULL THEN