<select id="getChargebackFineSettingByMerno" resultType="java.util.Map"> SELECT t.id,t.merno,T .CREDITCARDID,t.COMPUTE_MODE,t.FINE_MONEYTYPE, TO_CHAR(T2.START_TIME,'yyyy-mm-dd') START_TIME,TO_CHAR(T2.END_TIME,'yyyy-mm-dd') END_TIME FROM CHARGEBACK_FINE_SETTING T, ( SELECT T.CBFINE_SETTING_ID, T .START_TIME, T .END_TIME FROM CHARGEBACK_FINE_SETTING_DETAIL T GROUP BY T.CBFINE_SETTING_ID, T .START_TIME, T .END_TIME ) t2 WHERE T . ID = T2.CBFINE_SETTING_ID AND T .merno LIKE '%${merno}%' AND T2.START_TIME <= TO_DATE (#{time}, 'yyyy/MM') AND T2.END_TIME >= TO_DATE (#{time}, 'yyyy/MM') </select>