530: close get_country;
531: begin
532: SELECT substr(hr.meaning,1,30)
533: INTO X_REGION_1
534: FROM HR_LOOKUPS hr
535: WHERE hr.LOOKUP_CODE = l_county
536: AND hr.LOOKUP_TYPE = 'GB_COUNTY';
537: EXCEPTION WHEN NO_DATA_FOUND THEN
538: null;