SELECT
    KK0441.SEIOPSVC_KEI_NO,
    KK0441.SEIOPSVC_KEI_STAT,
    KK0441.SEIKY_KEI_NO,
    KK0441.PPLAN_CD,
    KK0441.SVC_CHRG_STAYMD,
    KK0441.SVC_CHRG_ENDYMD,
    ''
FROM
    (
        SELECT
            KK0441_SUB.SEIOPSVC_KEI_NO,
            KK0441_SUB.SEIOPSVC_KEI_STAT,
            KK0441_SUB.SEIKY_KEI_NO,
            KK0441_SUB.PPLAN_CD,
            KK0441_SUB.SVC_CHRG_STAYMD,
            KK0441_SUB.SVC_CHRG_ENDYMD,
            KK0441_SUB.GENE_ADD_DTM,
            KK0441_SUB.RSV_APLY_YMD,
            KK0441_SUB.RSV_APLY_CD,
            KK0441_SUB.MK_FLG,
            MAX(KK0441_SUB.RSV_APLY_YMD || KK0441_SUB.GENE_ADD_DTM)
                OVER (PARTITION BY KK0441_SUB.SEIOPSVC_KEI_NO) AS GENE_ADD_DTM_MAX
        FROM
            KK_T_SEIOPSVC_KEI KK0441_SUB
        WHERE
            KK0441_SUB.RSV_APLY_YMD <= '${RSV_APLY_YMD}'
        AND KK0441_SUB.RSV_APLY_CD   = '2'
        AND KK0441_SUB.MK_FLG = '0'
    ) KK0441
WHERE
    KK0441.GENE_ADD_DTM_MAX = KK0441.RSV_APLY_YMD || KK0441.GENE_ADD_DTM