SELECT
    MAX(EVENT_YMD)
FROM
    CH_M_PRC_SCHDL_TEIGI CH0501
WHERE
    CH0501.EVENT_CD  = :EVENT_CD
AND CH0501.MK_FLG    = '0'
AND CH0501.EVENT_YMD < :OPE_DATE