APPS.HR_H2PI_MAPPING_SETUP dependencies on PAY_ELEMENT_TYPES_F

Line 147: -- Inserts the mapping records for 'PAY_ELEMENT_TYPES_F' table.

143: OR map.to_id = pay2.payroll_id)
144: AND map.table_name = 'PAY_ALL_PAYROLLS_F'
145: AND map.to_business_group_id = l_to_business_group_id);
146: --
147: -- Inserts the mapping records for 'PAY_ELEMENT_TYPES_F' table.
148: --
149: hr_utility.set_location(l_proc, 60);
150: INSERT INTO hr_h2pi_id_mapping
151: (from_id, to_id, to_business_group_id, table_name)

Line 155: 'PAY_ELEMENT_TYPES_F'

151: (from_id, to_id, to_business_group_id, table_name)
152: SELECT et1.element_type_id,
153: et2.element_type_id,
154: l_to_business_group_id,
155: 'PAY_ELEMENT_TYPES_F'
156: FROM hr_h2pi_element_types et1,
157: pay_element_types_f et2
158: WHERE ((et2.business_group_id IS NULL
159: AND et2.legislation_code = 'US')

Line 157: pay_element_types_f et2

153: et2.element_type_id,
154: l_to_business_group_id,
155: 'PAY_ELEMENT_TYPES_F'
156: FROM hr_h2pi_element_types et1,
157: pay_element_types_f et2
158: WHERE ((et2.business_group_id IS NULL
159: AND et2.legislation_code = 'US')
160: OR (et2.business_group_id = l_to_business_group_id
161: AND et2.attribute2 = 'Y'))

Line 168: AND map.table_name = 'PAY_ELEMENT_TYPES_F'

164: AND NOT EXISTS (SELECT 1
165: FROM hr_h2pi_id_mapping map
166: WHERE (map.from_id = et1.element_type_id
167: OR map.to_id = et2.element_type_id)
168: AND map.table_name = 'PAY_ELEMENT_TYPES_F'
169: AND map.to_business_group_id = l_to_business_group_id);
170: --
171: -- Inserts the mapping records for 'PAY_INPUT_VALUES_F' table.
172: --

Line 183: pay_element_types_f et2

179: 'PAY_INPUT_VALUES_F'
180: FROM hr_h2pi_input_values iv1,
181: pay_input_values_f iv2,
182: hr_h2pi_element_types et1,
183: pay_element_types_f et2
184: WHERE ((et2.business_group_id IS NULL
185: AND et2.legislation_code = 'US')
186: OR (et2.business_group_id = l_to_business_group_id
187: AND et2.attribute2 = 'Y'))

Line 212: pay_element_types_f et2

208: 'PAY_ELEMENT_LINKS_F'
209: FROM hr_h2pi_element_links el1,
210: pay_element_links_f el2,
211: hr_h2pi_element_types et1,
212: pay_element_types_f et2
213: WHERE ((et2.business_group_id IS NULL
214: AND et2.legislation_code = 'US')
215: OR (et2.business_group_id = l_to_business_group_id
216: AND et2.attribute2 = 'Y'))