APPS.PER_DIS_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 806: from hr_organization_information hoi

802: and hou.internal_external_flag = 'EXT';
803: --
804: cursor csr_org_inf is
805: select null
806: from hr_organization_information hoi
807: where hoi.organization_id = p_organization_id
808: and hoi.org_information_context = 'CLASS'
809: and hoi.org_information1 = 'DISABILITY_ORG'
810: and hoi.org_information2 = 'Y';

Line 865: -- check org exists in hr_organization_information for the relevant

861: end if;
862: close csr_org;
863: hr_utility.set_location(l_proc, 40);
864: --
865: -- check org exists in hr_organization_information for the relevant
866: -- organisation class.
867: open csr_org_inf;
868: fetch csr_org_inf into l_exists;
869: if csr_org_inf%notfound then