APPS.PER_US_VISA_MIGR dependencies on PER_PEOPLE_EXTRA_INFO

Line 118: INSERT INTO per_people_extra_info

114: --
115: -- Insert statement here
116: --
117: IF l_new_code IS NOT NULL THEN
118: INSERT INTO per_people_extra_info
119: (person_extra_info_id,
120: person_id,
121: information_type,
122: pei_information_category,

Line 129: per_people_extra_info_s.nextval,

125: object_version_number,
126: last_update_date,
127: creation_date)
128: SELECT
129: per_people_extra_info_s.nextval,
130: l_person_id,
131: 'PER_US_VISA_DETAILS',
132: 'PER_US_VISA_DETAILS',
133: l_new_code,

Line 141: FROM PER_PEOPLE_EXTRA_INFO

137: sysdate
138: FROM sys.dual
139: WHERE NOT EXISTS
140: (SELECT 1
141: FROM PER_PEOPLE_EXTRA_INFO
142: WHERE person_id = l_person_id
143: AND pei_information5 = l_new_code
144: AND information_type = 'PER_US_VISA_DETAILS'
145: AND pei_information_category = 'PER_US_VISA_DETAILS');