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')
160: OR (et2.business_group_id = l_to_business_group_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')
186: OR (et2.business_group_id = l_to_business_group_id
207: l_to_business_group_id,
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