DBA Data[Home] [Help]

APPS.POR_LOAD_LOCATION dependencies on HR_LOCATIONS_ALL

Line 131: FROM hr_locations_all

127: BEGIN
128:
129:
130: SELECT 1 INTO l_count
131: FROM hr_locations_all
132: WHERE location_code = p_location_code AND business_group_id = l_business_grp_id;
133:
134:
135: RETURN true;

Line 164: FROM hr_locations_all

160: BEGIN
161:
162: SELECT location_id, object_version_number
163: INTO p_location_id, p_object_version_number
164: FROM hr_locations_all
165: WHERE location_code = p_location_code;
166:
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN

Line 208: FROM hr_locations_all

204: l_location_id NUMBER;
205: BEGIN
206:
207: SELECT location_id INTO l_location_id
208: FROM hr_locations_all
209: WHERE location_code = p_location_code;
210:
211: RETURN l_location_id;
212: EXCEPTION