7048: (
7049: p_location_id in number
7050: ) return varchar2 is
7051:
7052: l_location_name hr_locations.location_code%type := null;
7053:
7054: cursor c_location_name is
7055: select loc.location_code
7056: from hr_locations loc
7052: l_location_name hr_locations.location_code%type := null;
7053:
7054: cursor c_location_name is
7055: select loc.location_code
7056: from hr_locations loc
7057: where loc.location_id = p_location_id;
7058:
7059: begin
7060: open c_location_name;