DBA Data[Home] [Help]

APPS.PER_FR_WORK_ACC_UPG_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 20: FROM per_people_extra_info pei

16: pei.PEI_INFORMATION7,
17: pei.PEI_INFORMATION8,
18: pei.PEI_INFORMATION9,
19: pei.PERSON_EXTRA_INFO_ID
20: FROM per_people_extra_info pei
21: , per_all_people_f per1
22: WHERE pei.PEI_INFORMATION_CATEGORY = 'FR_WORK_ACCI'
23: AND pei.person_id = per1.person_id
24: AND per1.business_group_id = p_business_group_id

Line 163: update per_people_extra_info

159: ,p_absence_exists_flag => l_absence_exists_flag
160: ,p_incident_id => l_incident_id
161: ,p_object_version_number => l_ovn);
162:
163: update per_people_extra_info
164: set PEI_INFORMATION30 = to_char(l_incident_id)
165: where person_id = l_work_acci.person_id
166: and PEI_INFORMATION_CATEGORY = 'FR_WORK_ACCI'
167: and PERSON_EXTRA_INFO_ID = l_work_Acci.PERSON_EXTRA_INFO_ID;