1241: l_return_value varchar2(60) := NULL ;
1242: --
1243: cursor c1 is
1244: select location_code
1245: from hr_locations
1246: where location_id = p_location_id ;
1247: --
1248: begin
1249: --
1564: where x.grade_id = p_grade_id ;
1565: --
1566: cursor get_location is
1567: select l.location_code
1568: from hr_locations l
1569: where l.location_id = p_location_id ;
1570: --
1571: begin
1572: if p_vacancy_name is null then