DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on PAY_INPUT_VALUES_F

Line 171: -- Inserts the mapping records for 'PAY_INPUT_VALUES_F' table.

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: --
173: hr_utility.set_location(l_proc, 70);
174: INSERT INTO hr_h2pi_id_mapping
175: (from_id, to_id, to_business_group_id, table_name)

Line 179: 'PAY_INPUT_VALUES_F'

175: (from_id, to_id, to_business_group_id, table_name)
176: SELECT iv1.input_value_id,
177: iv2.input_value_id,
178: l_to_business_group_id,
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

Line 181: pay_input_values_f iv2,

177: iv2.input_value_id,
178: l_to_business_group_id,
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')

Line 197: AND map.table_name = 'PAY_INPUT_VALUES_F'

193: AND NOT EXISTS (SELECT 1
194: FROM hr_h2pi_id_mapping map
195: WHERE (map.from_id = iv1.input_value_id
196: OR map.to_id = iv2.input_value_id)
197: AND map.table_name = 'PAY_INPUT_VALUES_F'
198: AND map.to_business_group_id = l_to_business_group_id);
199: --
200: -- Inserts the mapping records for 'PAY_ELEMENT_LINKS_F' table.
201: --