APPS.HR_ORI_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 903: l_name hr_all_organization_units.name%TYPE;

899: p_org_information2 IN hr_organization_information.org_information2%TYPE
900: )
901: IS
902: l_proc VARCHAR2(72) := g_package||'chk_name';
903: l_name hr_all_organization_units.name%TYPE;
904: l_exists number;
905: BEGIN
906: --
907: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 917: select name into l_name from hr_all_organization_units where organization_id = p_organization_id;

913: --
914: -- Check that the business group name is unique if we are adding or updating to
915: -- a business group classification
916: --
917: select name into l_name from hr_all_organization_units where organization_id = p_organization_id;
918:
919: if p_org_information1 = 'HR_BG'
920: and p_org_information_context = 'CLASS'
921: and p_org_information2 = 'Y' then

Line 925: from hr_organization_information i, hr_all_organization_units u

921: and p_org_information2 = 'Y' then
922:
923: select count(*)
924: into l_exists
925: from hr_organization_information i, hr_all_organization_units u
926: where i.organization_id <> p_organization_id
927: and i.organization_id = u.organization_id
928: and i.org_information1='HR_BG'
929: and i.org_information_context='CLASS'

Line 1316: -- HR_ALL_ORGANIZATION_UNITS table and valid.

1312: -- ----------------------------------------------------------------------------
1313: --
1314: -- Description:
1315: -- Validates that organization_id of organization unit is present in
1316: -- HR_ALL_ORGANIZATION_UNITS table and valid.
1317: --
1318: -- Pre-conditions:
1319: -- None.
1320: --

Line 1362: FROM hr_all_organization_units

1358: INTO l_exists
1359: FROM sys.dual
1360: WHERE EXISTS
1361: (SELECT null
1362: FROM hr_all_organization_units
1363: WHERE organization_id = p_organization_id);
1364: EXCEPTION
1365: WHEN NO_DATA_FOUND THEN NULL;
1366: END;

Line 1612: -- ,hr_all_organization_units haou

1608: --
1609: -- AND hoit.legislation_code =
1610: -- (SELECT pbg.legislation_code
1611: -- FROM per_business_groups pbg
1612: -- ,hr_all_organization_units haou
1613: -- WHERE haou.organization_id = p_organization_id
1614: -- AND haou.business_group_id = pbg.business_group_id)
1615: --
1616: hr_utility.set_location(l_proc, 20);

Line 1710: from hr_all_organization_units

1706: ) is
1707: --
1708: cursor csr_location is
1709: select location_id
1710: from hr_all_organization_units
1711: where organization_id = p_organization_id;
1712: --
1713: l_location_id number;
1714: --

Line 1882: from hr_all_organization_units

1878: l_bg_id number ;
1879: -- Fetch BG Id from Org id.
1880: cursor C_BG is
1881: select business_group_id
1882: from hr_all_organization_units
1883: where organization_id = p_organization_id;
1884:
1885: Begin
1886: Open c_bg;