APPS.HR_LEI_BUS dependencies on HR_GENERAL

Line 697: and hoi.organization_id = nvl(loc.business_group_id,nvl(hr_general.get_business_group_id, -99))

693: select hoi.org_information14, hoi.org_information9
694: from hr_organization_information hoi
695: , hr_locations_all loc
696: where loc.location_id = p_rec.location_id
697: and hoi.organization_id = nvl(loc.business_group_id,nvl(hr_general.get_business_group_id, -99))
698: and hoi.org_information_context||'' = 'Business Group Information';
699:
700: l_security_group_id number;
701: l_legislation_code varchar2(150);

Line 779: and hoi.organization_id = nvl(loc.business_group_id,nvl(hr_general.get_business_group_id, -99))

775: select hoi.org_information14, hoi.org_information9
776: from hr_organization_information hoi
777: , hr_locations_all loc
778: where loc.location_id = p_rec.location_id
779: and hoi.organization_id = nvl(loc.business_group_id,nvl(hr_general.get_business_group_id, -99))
780: and hoi.org_information_context||'' = 'Business Group Information';
781:
782: l_security_group_id number;
783: l_legislation_code varchar2(150);