APPS.HR_ORU_BUS dependencies on HR_ORGANIZATION

Line 88: from HR_ORGANIZATION_INFORMATION ORI,

84: -- Declare cursor
85: --
86: cursor csr_leg_code is
87: select ORI.ORG_INFORMATION9
88: from HR_ORGANIZATION_INFORMATION ORI,
89: HR_ALL_ORGANIZATION_UNITS ORU
90: where ORI.ORGANIZATION_ID=ORU.BUSINESS_GROUP_ID
91: and ORU.ORGANIZATION_ID=p_organization_id
92: and ORI.ORG_INFORMATION_CONTEXT='Business Group Information'; -- changes for bug14506616

Line 545: from hr_organization_information i

541: for Crec in C1 loop
542:
543: select count(*)
544: into l_bg
545: from hr_organization_information i
546: where i.organization_id = crec.organization_id
547: and i.org_information1='HR_BG'
548: and i.org_information_context='CLASS'
549: and i.org_information2 ='Y';

Line 745: FROM hr_organization_information

741: IF p_organization_id IS NOT NULL THEN
742: --
743: SELECT COUNT(*)
744: INTO l_count
745: FROM hr_organization_information
746: WHERE organization_id = p_organization_id
747: AND org_information_context = 'CLASS'
748: AND org_information1 = 'HR_ORG'
749: AND org_information2 = 'Y';

Line 1051: FROM hr_organization_information

1047: INTO l_exists
1048: FROM sys.dual
1049: WHERE EXISTS
1050: (SELECT null
1051: FROM hr_organization_information
1052: WHERE organization_id = p_organization_id
1053: AND org_information_context = 'CLASS'
1054: AND org_information2 = 'Y'
1055: );

Line 1295: hr_organization.org_predel_check(p_rec.organization_id,

1291: hr_utility.set_location(l_proc, 20);
1292: --
1293: -- Validate Person, Org and Hierarchies exists
1294: -- ===========================================
1295: hr_organization.org_predel_check(p_rec.organization_id,
1296: l_bg_id);
1297: hr_utility.set_location(l_proc, 25);
1298: --
1299: -- Product specific validations