APPS.HR_LEI_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 684: from hr_organization_information hoi

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

Line 694: from hr_organization_information hoi

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

Line 766: from hr_organization_information hoi

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

Line 776: from hr_organization_information hoi

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