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 684: , hr_locations_all loc

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';
688: l_security_group_id number;

Line 753: , hr_locations_all loc

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';
757: l_security_group_id number;