SELECT
    TO_CHAR(TO_DATE(CH0501.EVENT_YMD) + :ADD_DAY, 'YYYYMMDD') AS EVENT_YMD
FROM
    CH_M_PRC_SCHDL_TEIGI CH0501
WHERE
    CH0501.SEIKY_YM = :SEIKY_YM
AND CH0501.EVENT_CD = :EVENT_CD
AND CH0501.MK_FLG   = '0'