/*------------------------------------------------------------
-- 督促スキーマのアンロード
------------------------------------------------------------*/
SELECT
    CH0231.TOKUSOKU_NO
    ,CH0231.TOKUSOKU_STAT
    ,CH0231.SEIKY_KEI_NO
    ,to_char(CH0231.TOKUSOKU_AMNT)
FROM
    CH_T_TOKUSOKU CH0231
WHERE
        CH0231.TOKUSOKU_STAYMD <= :OPEDATE
    AND CH0231.TOKUSOKU_ENDYMD > :OPEDATE
    AND CH0231.MK_FLG = '0'