APPS.HR_REGISTER_EITS dependencies on PER_ASSIGNMENT_INFO_TYPES_TL

Line 110: insert into PER_ASSIGNMENT_INFO_TYPES_TL

106: ,1);
107: --
108: fnd_file.put_line(fnd_file.log,l_insert);
109:
110: insert into PER_ASSIGNMENT_INFO_TYPES_TL
111: (INFORMATION_TYPE
112: ,LANGUAGE
113: ,SOURCE_LANG
114: ,DESCRIPTION

Line 137: from per_assignment_info_types_tl pait

133: where M.INFORMATION_TYPE = v_info_type_name
134: and L.INSTALLED_FLAG in ('I', 'B')
135: and B.INSTALLED_FLAG = 'B'
136: and not exists (select '1'
137: from per_assignment_info_types_tl pait
138: where pait.information_type = m.information_type
139: and pait.language = l.language_code);
140: --
141: fnd_file.put_line(fnd_file.log,l_insert);