DBA Data[Home] [Help]

APPS.HR_LEI_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 683: from hr_organization_information hoi

679: -- bug 6329528
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';

Line 752: from hr_organization_information hoi

748: --
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';