eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_H2PI_ID_MAPPING

Line 23: INSERT INTO hr_h2pi_id_mapping

19: l_to_business_group_id := hr_h2pi_upload.g_to_business_group_id;
20: --
21: -- Inserts the mapping records for 'HR_LOCATIONS_ALL' table.
22: --
23: INSERT INTO hr_h2pi_id_mapping
24: (from_id, to_id, to_business_group_id, table_name)
25: SELECT loc1.location_id,
26: loc2.location_id,
27: l_to_business_group_id,

Line 35: FROM hr_h2pi_id_mapping map

31: WHERE loc1.client_id = l_from_client_id
32: AND loc2.business_group_id = l_to_business_group_id
33: AND loc1.location_code = loc2.location_code
34: AND NOT EXISTS (SELECT 1
35: FROM hr_h2pi_id_mapping map
36: WHERE (map.from_id = loc1.location_id
37: OR map.to_id = loc2.location_id)
38: AND map.table_name = 'HR_LOCATIONS_ALL'
39: AND map.to_business_group_id = l_to_business_group_id);

Line 44: INSERT INTO hr_h2pi_id_mapping

40: --
41: -- Inserts the mapping records for 'PER_PAY_BASES' table.
42: --
43: hr_utility.set_location(l_proc, 20);
44: INSERT INTO hr_h2pi_id_mapping
45: (from_id, to_id, to_business_group_id, table_name)
46: SELECT ppb1.pay_basis_id,
47: ppb2.pay_basis_id,
48: l_to_business_group_id,

Line 56: FROM hr_h2pi_id_mapping map

52: WHERE ppb1.client_id = l_from_client_id
53: AND ppb2.business_group_id = l_to_business_group_id
54: AND ppb1.name = ppb2.name
55: AND NOT EXISTS (SELECT 1
56: FROM hr_h2pi_id_mapping map
57: WHERE (map.from_id = ppb1.pay_basis_id
58: OR map.to_id = ppb2.pay_basis_id)
59: AND map.table_name = 'PER_PAY_BASES'
60: AND map.to_business_group_id = l_to_business_group_id);

Line 65: INSERT INTO hr_h2pi_id_mapping

61: --
62: -- Inserts the mapping records for 'HR_ALL_ORGANIZATION_UNITS' table.
63: --
64: hr_utility.set_location(l_proc, 30);
65: INSERT INTO hr_h2pi_id_mapping
66: (from_id, to_id, to_business_group_id, table_name)
67: SELECT v1.from_org_id,
68: v2.to_org_id,
69: l_to_business_group_id,

Line 83: FROM hr_h2pi_id_mapping map

79: FROM hr_h2pi_bg_and_gre_v org
80: WHERE org.business_group_id = l_to_business_group_id) v2
81: WHERE v1.name = v2.name
82: AND NOT EXISTS (SELECT 1
83: FROM hr_h2pi_id_mapping map
84: WHERE (map.from_id = v1.from_org_id
85: OR map.to_id = v2.to_org_id)
86: AND map.table_name = 'HR_ALL_ORGANIZATION_UNITS'
87: AND map.to_business_group_id = l_to_business_group_id);

Line 92: INSERT INTO hr_h2pi_id_mapping

88: --
89: -- Inserts the mapping records for 'HR_ORGANIZATION_INFORMATION' table.
90: --
91: hr_utility.set_location(l_proc, 40);
92: INSERT INTO hr_h2pi_id_mapping
93: (from_id, to_id, to_business_group_id, table_name)
94: SELECT v1.from_org_info_id,
95: v2.to_org_info_id,
96: l_to_business_group_id,

Line 119: FROM hr_h2pi_id_mapping map

115: AND org.business_group_id = l_to_business_group_id) v2
116: WHERE v1.org_name = v2.org_name
117: AND v1.org_info_name = v2.org_info_name
118: AND NOT EXISTS (SELECT 1
119: FROM hr_h2pi_id_mapping map
120: WHERE (map.from_id = v1.from_org_info_id
121: OR map.to_id = v2.to_org_info_id)
122: AND map.table_name = 'HR_ORGANIZATION_INFORMATION'
123: AND map.to_business_group_id = l_to_business_group_id);

Line 129: INSERT INTO hr_h2pi_id_mapping

125: --
126: -- Inserts the mapping records for 'PAY_ALL_PAYROLLS_F' table.
127: --
128: hr_utility.set_location(l_proc, 50);
129: INSERT INTO hr_h2pi_id_mapping
130: (from_id, to_id, to_business_group_id, table_name)
131: SELECT pay1.payroll_id,
132: pay2.payroll_id,
133: l_to_business_group_id,

Line 141: FROM hr_h2pi_id_mapping map

137: WHERE pay1.payroll_name = pay2.payroll_name
138: AND pay1.client_id = l_from_client_id
139: AND pay2.business_group_id = l_to_business_group_id
140: AND NOT EXISTS (SELECT 1
141: FROM hr_h2pi_id_mapping map
142: WHERE (map.from_id = pay1.payroll_id
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);

Line 150: INSERT INTO hr_h2pi_id_mapping

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)
152: SELECT et1.element_type_id,
153: et2.element_type_id,
154: l_to_business_group_id,

Line 165: FROM hr_h2pi_id_mapping map

161: AND et2.attribute2 = 'Y'))
162: AND et1.client_id = l_from_client_id
163: AND et1.element_name = et2.element_name
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);

Line 174: INSERT INTO hr_h2pi_id_mapping

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

Line 194: FROM hr_h2pi_id_mapping map

190: AND et1.element_name = et2.element_name
191: AND iv1.element_type_id = et1.element_type_id
192: AND iv2.element_type_id = et2.element_type_id
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);

Line 203: INSERT INTO hr_h2pi_id_mapping

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)
205: SELECT el1.element_link_id,
206: el2.element_link_id,
207: l_to_business_group_id,

Line 224: FROM hr_h2pi_id_mapping map

220: AND el2.business_group_id = l_to_business_group_id
221: AND et1.client_id = l_from_client_id
222: AND et1.element_name = et2.element_name
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);

Line 233: INSERT INTO hr_h2pi_id_mapping

229: --
230: -- Inserts the mapping records for 'PAY_ORG_PAYMENT_METHODS_F' table.
231: --
232: hr_utility.set_location(l_proc, 90);
233: INSERT INTO hr_h2pi_id_mapping
234: (from_id, to_id, to_business_group_id, table_name)
235: SELECT opm1.org_payment_method_id,
236: opm2.org_payment_method_id,
237: l_to_business_group_id,

Line 245: FROM hr_h2pi_id_mapping map

241: WHERE opm1.client_id = l_from_client_id
242: AND opm2.business_group_id = l_to_business_group_id
243: AND opm1.org_payment_method_name = opm2.org_payment_method_name
244: AND NOT EXISTS (SELECT 1
245: FROM hr_h2pi_id_mapping map
246: WHERE (map.from_id = opm1.org_payment_method_id
247: OR map.to_id = opm2.org_payment_method_id)
248: AND map.table_name = 'PAY_ORG_PAYMENT_METHODS_F'
249: AND map.to_business_group_id = l_to_business_group_id);