APPS.HR_LEI_BUS dependencies on HR_LOCATIONS

Line 16: -- Verify that the value in LOCATION_ID is in the HR_LOCATIONS table.

12: -- ----------------------------------------------------------------------------
13: -- {Start Of Comments}
14: --
15: -- Description:
16: -- Verify that the value in LOCATION_ID is in the HR_LOCATIONS table.
17: --
18: -- Pre Conditions:
19: --
20: --

Line 50: from hr_locations

46: l_dummy varchar2(1);
47: --
48: cursor c_valid_loc is
49: select 'x'
50: from hr_locations
51: where location_id = p_location_id and location_use = 'HR';
52: --
53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 1);

Line 66: -- Check that the location_id is in the hr_locations table.

62: p_argument_value => p_location_id
63: );
64: hr_utility.set_location(l_proc, 2);
65: --
66: -- Check that the location_id is in the hr_locations table.
67: --
68: open c_valid_loc;
69: fetch c_valid_loc into l_dummy;
70: if c_valid_loc%notfound then

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: