SELECT
    CH0011.SEIKY_KEI_NO
   ,'1' AS ZZGT_MN_SAIKEN_FLG
FROM
    CH_T_SAIKEN CH0011
WHERE
    CH0011.SAIKEN_YM  <= :ZENZENGETU
AND CH0011.SAIKEN_STAT IN('020', '060')
AND CH0011.MK_FLG      = '0'