<?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 
	    ORDER BY REMARK;
 	</select>

    <!-- 유형 코드 목록  -->
    <select id="listTypeDivCodes" parameterType="String" resultType="EgovMap">
        SELECT S_CODE_ID AS TYPE_DIV_CD
             , S_CODE_NM AS TYPE_DIV_NM
        FROM SM_CODE_S
        WHERE L_CODE_ID = 'MASTER_TYPE_DIV_CD'
        AND USE_YN = 'Y'
        ORDER BY SORT_SEQ 
    </select>
  	
</mapper>