APPS.HR_ORI_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 824: , hr_all_organization_units org -- Modified for bug # 6794638 to pick from base table

820: /*cursor csr_leg_code is
821: select pbg.legislation_code
822: from per_business_groups pbg
823: , hr_organization_information ori
824: , hr_all_organization_units org -- Modified for bug # 6794638 to pick from base table
825: where ori.org_information_id = p_org_information_id
826: and org.organization_id = ori.organization_id
827: and pbg.business_group_id = org.business_group_id; -- AT 27/9/01 */
828:

Line 831: hr_all_organization_units org,

827: and pbg.business_group_id = org.business_group_id; -- AT 27/9/01 */
828:
829: cursor csr_leg_code is
830: select ori2.ORG_INFORMATION9 from
831: hr_all_organization_units org,
832: hr_organization_information ori1,
833: hr_organization_information ori2
834: where ori1.ORG_INFORMATION_ID=p_org_information_id
835: and org.ORGANIZATION_ID=ori1.ORGANIZATION_ID

Line 913: l_name hr_all_organization_units.name%TYPE;

909: p_org_information2 IN hr_organization_information.org_information2%TYPE
910: )
911: IS
912: l_proc VARCHAR2(72) := g_package||'chk_name';
913: l_name hr_all_organization_units.name%TYPE;
914: l_exists number;
915: BEGIN
916: --
917: hr_utility.set_location('Entering:'|| l_proc, 10);

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

923: --
924: -- Check that the business group name is unique if we are adding or updating to
925: -- a business group classification
926: --
927: select name into l_name from hr_all_organization_units where organization_id = p_organization_id;
928:
929: if p_org_information1 = 'HR_BG'
930: and p_org_information_context = 'CLASS'
931: and p_org_information2 = 'Y' then

Line 935: from hr_organization_information i, hr_all_organization_units u

931: and p_org_information2 = 'Y' then
932:
933: select count(*)
934: into l_exists
935: from hr_organization_information i, hr_all_organization_units u
936: where i.organization_id <> p_organization_id
937: and i.organization_id = u.organization_id
938: and i.org_information1='HR_BG'
939: and i.org_information_context='CLASS'

Line 1326: -- HR_ALL_ORGANIZATION_UNITS table and valid.

1322: -- ----------------------------------------------------------------------------
1323: --
1324: -- Description:
1325: -- Validates that organization_id of organization unit is present in
1326: -- HR_ALL_ORGANIZATION_UNITS table and valid.
1327: --
1328: -- Pre-conditions:
1329: -- None.
1330: --

Line 1372: FROM hr_all_organization_units

1368: INTO l_exists
1369: FROM sys.dual
1370: WHERE EXISTS
1371: (SELECT null
1372: FROM hr_all_organization_units
1373: WHERE organization_id = p_organization_id);
1374: EXCEPTION
1375: WHEN NO_DATA_FOUND THEN NULL;
1376: END;

Line 1622: -- ,hr_all_organization_units haou

1618: --
1619: -- AND hoit.legislation_code =
1620: -- (SELECT pbg.legislation_code
1621: -- FROM per_business_groups pbg
1622: -- ,hr_all_organization_units haou
1623: -- WHERE haou.organization_id = p_organization_id
1624: -- AND haou.business_group_id = pbg.business_group_id)
1625: --
1626: hr_utility.set_location(l_proc, 20);

Line 1720: from hr_all_organization_units

1716: ) is
1717: --
1718: cursor csr_location is
1719: select location_id
1720: from hr_all_organization_units
1721: where organization_id = p_organization_id;
1722: --
1723: l_location_id number;
1724: --

Line 1892: from hr_all_organization_units

1888: l_bg_id number ;
1889: -- Fetch BG Id from Org id.
1890: cursor C_BG is
1891: select business_group_id
1892: from hr_all_organization_units
1893: where organization_id = p_organization_id;
1894:
1895: Begin
1896: Open c_bg;