APPS.PER_ELC_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 24: -- table HR_ORGANIZATION_INFORMATION

20: -- Description:
21: -- - Validates that a representative body id exists in table
22: -- HR_ALL_ORGANIZATION_UNITS.
23: -- - Validates that the rep_body_id compares with that in
24: -- table HR_ORGANIZATION_INFORMATION
25: --
26: -- Pre-conditions:
27: -- None.
28: --

Line 66: from hr_organization_information hoi

62: select hou.organization_id
63: from hr_all_organization_units hou
64: where hou.organization_id = p_rep_body_id
65: and exists(select 1
66: from hr_organization_information hoi
67: where hoi.organization_id = hou.organization_id
68: and hoi.org_information_context='CLASS'
69: and hoi.org_information1='REPBODY'
70: and hoi.org_information2='Y');

Line 249: -- Cursor for text compare. From hr_organization_information

245: l_proc varchar2(72) := g_package||'chk_rep_body_id';
246: --
247: l_api_updating boolean;
248: --
249: -- Cursor for text compare. From hr_organization_information
250: --
251: begin
252: hr_utility.set_location('Entering:'|| l_proc, 10);
253: --