131: RETURN VARCHAR2 IS
132:
133: cursor c_get_location_code is
134: select loc.location_code 135: from hr_locations loc 136: where loc.location_id = p_location_id;
137:
138: l_location_code hr_locations.location_code%TYPE;
139:
Line 138: l_location_code hr_locations.location_code%TYPE;
134: select loc.location_code
135: from hr_locations loc
136: where loc.location_id = p_location_id;
137: 138: l_location_code hr_locations.location_code%TYPE; 139:
140: BEGIN
141:
142: open c_get_location_code;