SELECT
    KK0491.SEIKY_KEI_NO
FROM
    KK_T_SEIKY_KEI KK0491
        INNER JOIN
        (
            SELECT
                KK0491_GENE.SEIKY_KEI_NO
               ,MAX(KK0491_GENE.GENE_ADD_DTM) AS MAX_GENE_ADD_DTM
            FROM
                KK_T_SEIKY_KEI KK0491_GENE
            WHERE
                    KK0491_GENE.RSV_APLY_CD = '2'
                AND KK0491_GENE.RSV_APLY_YMD <= :OPEDATE
                AND KK0491_GENE.MK_FLG = '0'
            GROUP BY
                KK0491_GENE.SEIKY_KEI_NO
        ) KK0491_GENE
        ON KK0491.SEIKY_KEI_NO = KK0491_GENE.SEIKY_KEI_NO
        AND KK0491.GENE_ADD_DTM = KK0491_GENE.MAX_GENE_ADD_DTM