DBA Data[Home] [Help]

APPS.HR_LEI_BUS dependencies on HR_LOCATIONS_ALL

Line 684: , hr_locations_all loc

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;

Line 753: , hr_locations_all loc

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;