APPS.HR_REGISTER_EITS dependencies on PER_CONTACT_INFO_TYPES_TL

Line 260: insert into PER_CONTACT_INFO_TYPES_TL

256: ,1);
257:
258: fnd_file.put_line(fnd_file.log,l_insert);
259: --
260: insert into PER_CONTACT_INFO_TYPES_TL
261: (INFORMATION_TYPE
262: , LANGUAGE
263: , SOURCE_LANG
264: , DESCRIPTION

Line 287: from per_contact_info_types_tl pcit

283: where M.INFORMATION_TYPE = v_info_type_name
284: and L.INSTALLED_FLAG in ('I', 'B')
285: and B.INSTALLED_FLAG = 'B'
286: and not exists ( select '1'
287: from per_contact_info_types_tl pcit
288: where pcit.information_type = m.information_type
289: and pcit.language = l.language_code);
290:
291: fnd_file.put_line(fnd_file.log,l_insert);