680: --
681: cursor csr_sec_grp is
682: select hoi.org_information14, hoi.org_information9
683: from hr_organization_information hoi
684: , hr_locations_all loc
685: where loc.location_id = p_rec.location_id
686: and hoi.organization_id = nvl(loc.business_group_id,0)
687: and hoi.org_information_context||'' = 'Business Group Information';
688: l_security_group_id number;
749: -- bug 6329528
750: cursor csr_sec_grp is
751: select hoi.org_information14, hoi.org_information9
752: from hr_organization_information hoi
753: , hr_locations_all loc
754: where loc.location_id = p_rec.location_id
755: and hoi.organization_id = nvl(loc.business_group_id,0)
756: and hoi.org_information_context||'' = 'Business Group Information';
757: l_security_group_id number;