SELECT
    KK0491.SEIKY_KEI_NO
FROM
    KK_T_SEIKY_KEI KK0491
INNER JOIN CH_T_SEIKY CH0051
    ON  CH0051.SEIKY_KEI_NO = KK0491.SEIKY_KEI_NO
WHERE
     CH0051.SEIKY_YM     = :SEIKY_YM
AND  CH0051.SEIKY_SBT_CD = '0'
AND  CH0051.SEIKY_WAY_CD IN('1','2','3')
AND  ( CH0051.SKHK_SVKEI_STAT_CD <> '910' OR CH0051.SKHK_SVKEI_STAT_CD IS NULL )
AND  CH0051.MK_FLG       = '0'
AND  KK0491.KYOSEI_DSL_YKK_CNT >= (
             SELECT ZM0321.WORK_PARAM_SETTE_VALUE
             FROM   ZM_M_WORK_PARAM_KNRI ZM0321
             WHERE  ZM0321.WORK_PARAM_ID = 'KK_KYOSEI_DSL_YKKCNT'
               AND  ZM0321.MK_FLG = '0')
AND  KK0491.RSV_APLY_YMD || KK0491.GENE_ADD_DTM =
         (   SELECT
               MAX(KK0491_GENE.RSV_APLY_YMD || KK0491_GENE.GENE_ADD_DTM) AS KK0491_MAX
             FROM
               KK_T_SEIKY_KEI KK0491_GENE
             WHERE
                   KK0491_GENE.SEIKY_KEI_NO  = KK0491.SEIKY_KEI_NO
               AND KK0491_GENE.RSV_APLY_YMD <= :OPE_DATE
               AND KK0491_GENE.RSV_APLY_CD   = '2'
               AND KK0491_GENE.MK_FLG        = '0'
         )
ORDER BY KK0491.SEIKY_KEI_NO