APPS.PER_FR_DISABILITY_UPG_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 19: FROM per_people_extra_info pei

15: pei.PEI_INFORMATION7,
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

Line 137: update per_people_extra_info

133: if l_run_status = 0 THEN /* only change status if not 1 or 2 already */
134: l_run_status := 1; -- Set status of run to warning.
135: end if;
136: -- Set the record status so that it is not processed in the future.
137: update per_people_extra_info
138: set PEI_INFORMATION30 = 'INVALID_DATES'
139: where person_id = l_disabled.person_id
140: and PEI_INFORMATION_CATEGORY = 'FR_DISABILITY'
141: and PERSON_EXTRA_INFO_ID = l_disabled.PERSON_EXTRA_INFO_ID;

Line 196: update per_people_extra_info

192: p_effective_start_date => l_effective_start_date,
193: p_effective_end_date => l_effective_end_date);
194: END IF; -- End of Disability End Date.
195:
196: update per_people_extra_info
197: set PEI_INFORMATION30 = to_char(l_disability_id)
198: where person_id = l_disabled.person_id
199: and PEI_INFORMATION_CATEGORY = 'FR_DISABILITY'
200: and PERSON_EXTRA_INFO_ID = l_disabled.PERSON_EXTRA_INFO_ID;