DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on PAY_ELEMENT_LINKS_F

Line 200: -- Inserts the mapping records for 'PAY_ELEMENT_LINKS_F' table.

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: --
202: hr_utility.set_location(l_proc, 80);
203: INSERT INTO hr_h2pi_id_mapping
204: (from_id, to_id, to_business_group_id, table_name)

Line 208: 'PAY_ELEMENT_LINKS_F'

204: (from_id, to_id, to_business_group_id, table_name)
205: SELECT el1.element_link_id,
206: el2.element_link_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

Line 210: pay_element_links_f el2,

206: el2.element_link_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')

Line 227: AND map.table_name = 'PAY_ELEMENT_LINKS_F'

223: AND NOT EXISTS (SELECT 1
224: FROM hr_h2pi_id_mapping map
225: WHERE (map.from_id = el1.element_link_id
226: OR map.to_id = el2.element_link_id)
227: AND map.table_name = 'PAY_ELEMENT_LINKS_F'
228: AND map.to_business_group_id = l_to_business_group_id);
229: --
230: -- Inserts the mapping records for 'PAY_ORG_PAYMENT_METHODS_F' table.
231: --