APPS.HR_LEI_BUS dependencies on HR_LOCATIONS_ALL

Line 685: , hr_locations_all loc

681: /*
682: cursor csr_sec_grp is
683: select hoi.org_information14, hoi.org_information9
684: from hr_organization_information hoi
685: , hr_locations_all loc
686: where loc.location_id = p_rec.location_id
687: and hoi.organization_id = nvl(loc.business_group_id,0)
688: and hoi.org_information_context||'' = 'Business Group Information';
689: */

Line 695: , hr_locations_all loc

691: -- fix for the bug 7653370 modified the above cursor..as follows
692: cursor csr_sec_grp is
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:

Line 767: , hr_locations_all loc

763: /*
764: cursor csr_sec_grp is
765: select hoi.org_information14, hoi.org_information9
766: from hr_organization_information hoi
767: , hr_locations_all loc
768: where loc.location_id = p_rec.location_id
769: and hoi.organization_id = nvl(loc.business_group_id,0)
770: and hoi.org_information_context||'' = 'Business Group Information';
771: */

Line 777: , hr_locations_all loc

773: -- fix for the bug 7653370 modified the above cursor..as follows
774: cursor csr_sec_grp is
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: