APPS.HR_REGISTER_EITS dependencies on PER_ASSIGNMENT_INFO_TYPES

Line 91: elsif v_table_name = 'PER_ASSIGNMENT_INFO_TYPES' then

87:
88:
89: --
90:
91: elsif v_table_name = 'PER_ASSIGNMENT_INFO_TYPES' then
92: --
93: INSERT INTO PER_ASSIGNMENT_INFO_TYPES
94: (INFORMATION_TYPE
95: ,ACTIVE_INACTIVE_FLAG

Line 93: INSERT INTO PER_ASSIGNMENT_INFO_TYPES

89: --
90:
91: elsif v_table_name = 'PER_ASSIGNMENT_INFO_TYPES' then
92: --
93: INSERT INTO PER_ASSIGNMENT_INFO_TYPES
94: (INFORMATION_TYPE
95: ,ACTIVE_INACTIVE_FLAG
96: ,MULTIPLE_OCCURENCES_FLAG
97: ,DESCRIPTION

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 130: from PER_ASSIGNMENT_INFO_TYPES M

126: ,M.LAST_UPDATED_BY
127: ,M.LAST_UPDATE_LOGIN
128: ,M.CREATED_BY
129: ,M.CREATION_DATE
130: from PER_ASSIGNMENT_INFO_TYPES M
131: ,FND_LANGUAGES L
132: ,FND_LANGUAGES B
133: where M.INFORMATION_TYPE = v_info_type_name
134: and L.INSTALLED_FLAG in ('I', 'B')

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