<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="nlib.cmm.service.impl.CodeDAO">

 	<select id="listCodes" parameterType="String" resultType="EgovMap">
		SELECT B.S_CODE_ID 
	      	 , B.COLUMN1
             , B.COLUMN2
		     , B.S_CODE_NM
		     
		FROM SM_CODE_M A,
		     SM_CODE_S B 
		WHERE A.L_CODE_ID = #{lCodeId} 
		AND A.L_CODE_ID = B.L_CODE_ID 
		AND A.USE_YN = 'Y'
		AND B.USE_YN = 'Y'
		ORDER BY B.SORT_SEQ
 	</select>
 	
 	<select id="listCtClsfs" resultType="EgovMap">
		SELECT
			   CLSF_ID
			  ,CLSF_NM
			  ,UP_CLSF_ID 
			  ,REMARK
		  FROM
		       CT_CLSF 
	      WHERE 1=1
	      ORDER BY REMARK;
 	</select>
 	
</mapper>