SELECT A.gd_tourism_seq
     , A.ba_comp_seq
     , A.area_cls_seq
     , FN_BA_CLASS_INFO_R01(A.area_cls_seq,'CLASS_NM') as area_nm
     , A.tourism_cd
     , A.tourism_nm
     , A.tourism_desc
     , A.tourism_mapxy
     , A.use_yn
     , A.img_path_arr
  FROM GD_TOURISM A
 WHERE A.gd_tourism_seq = :gd_tourism_seq