SELECT A.*
          ,B.gd_nm
		  ,B.include_desc
		  ,B.exclude_desc
		  ,FN_SY_CLASS_R01(A.rs_status_cd,'CLASS_NM') AS rs_status_nm
FROM RS_MST A
INNER JOIN GD_MST B ON A.gd_mst_seq = B.gd_mst_seq
WHERE A.rs_mst_seq = :rs_mst_seq