APPS.HR_ORU_BUS dependencies on HR_ORGANIZATION_INFORMATION

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