APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 14: l_to_business_group_id hr_all_organization_units.business_group_id%type;

10: -- Declaring the local variables to store the Source (HR side) and
11: -- Destination(payroll side) Business Group Id and Name.
12: --
13: l_from_client_id NUMBER(15);
14: l_to_business_group_id hr_all_organization_units.business_group_id%type;
15: --
16: BEGIN
17: hr_utility.set_location('Entering:'|| l_proc, 10);
18: l_from_client_id := p_from_client_id;

Line 62: -- Inserts the mapping records for 'HR_ALL_ORGANIZATION_UNITS' table.

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);
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)

Line 70: 'HR_ALL_ORGANIZATION_UNITS'

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,
70: 'HR_ALL_ORGANIZATION_UNITS'
71: FROM ( SELECT distinct org.organization_id from_org_id,
72: org.business_group_id,
73: org.name
74: FROM hr_h2pi_bg_and_gre org

Line 86: AND map.table_name = 'HR_ALL_ORGANIZATION_UNITS'

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);
88: --
89: -- Inserts the mapping records for 'HR_ORGANIZATION_INFORMATION' table.
90: --

Line 262: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;

258:
259:
260: l_proc VARCHAR2(72) := g_package||'mapping_id_upload';
261:
262: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
263: l_from_client_id hr_all_organization_units.organization_id%TYPE;
264:
265: BEGIN
266: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 263: l_from_client_id hr_all_organization_units.organization_id%TYPE;

259:
260: l_proc VARCHAR2(72) := g_package||'mapping_id_upload';
261:
262: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
263: l_from_client_id hr_all_organization_units.organization_id%TYPE;
264:
265: BEGIN
266: hr_utility.set_location('Entering:'|| l_proc, 10);
267: hr_h2pi_upload.g_request_id :=