APPS.HR_REGISTER_EITS dependencies on PER_CONTACT_INFO_TYPES

Line 242: elsif v_table_name = 'PER_CONTACT_INFO_TYPES' then

238: ,1);
239:
240: fnd_file.put_line(fnd_file.log,l_insert);
241:
242: elsif v_table_name = 'PER_CONTACT_INFO_TYPES' then
243: --
244:
245: INSERT INTO PER_CONTACT_INFO_TYPES
246: (INFORMATION_TYPE

Line 245: INSERT INTO PER_CONTACT_INFO_TYPES

241:
242: elsif v_table_name = 'PER_CONTACT_INFO_TYPES' then
243: --
244:
245: INSERT INTO PER_CONTACT_INFO_TYPES
246: (INFORMATION_TYPE
247: ,ACTIVE_INACTIVE_FLAG
248: ,MULTIPLE_OCCURENCES_FLAG
249: ,LEGISLATION_CODE

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 280: from PER_CONTACT_INFO_TYPES M

276: , M.LAST_UPDATED_BY
277: , M.LAST_UPDATE_LOGIN
278: , M.CREATED_BY
279: , M.CREATION_DATE
280: from PER_CONTACT_INFO_TYPES M
281: , FND_LANGUAGES L
282: , FND_LANGUAGES B
283: where M.INFORMATION_TYPE = v_info_type_name
284: and L.INSTALLED_FLAG in ('I', 'B')

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);