SELECT
    CN0041.CONT_SVC_CD
    ,CN0041.CONT_SVC_NM
FROM
    CN_M_CONT_SVC CN0041
WHERE
    :OPEDATE BETWEEN CN0041.CONT_SVC_TSTAYMD AND CN0041.CONT_SVC_TENDYMD
    AND  CN0041.MK_FLG = '0'