SELECT
    KK0481.WRIB_SVC_KEI_NO
    ,SVC_KEI_NO
    ,KK0481.WRISVC_TG_KEI_TSTAYMD
FROM
    KK_T_WRISVC_TG_KEI KK0481
WHERE
    ( KK0481.GENE_ADD_DTM, KK0481.WRIB_SVC_KEI_NO, KK0481.WRIB_SVC_TRGT_KEI_NO )
    IN
    (
        SELECT
            MAX(KK0481_GENE1.GENE_ADD_DTM) AS KK0481_GENE1_MAX
           ,KK0481_GENE1.WRIB_SVC_KEI_NO
           ,KK0481_GENE1.WRIB_SVC_TRGT_KEI_NO
        FROM
             KK_T_WRISVC_TG_KEI KK0481_GENE1
        WHERE
                KK0481_GENE1.SVC_KEI_NO             = KK0481.SVC_KEI_NO
            AND KK0481_GENE1.WRIB_SVC_TRGT_KEI_NO   = KK0481.WRIB_SVC_TRGT_KEI_NO
            AND KK0481_GENE1.WRISVC_TG_KEI_TSTAYMD <= :OPEDATE
            AND KK0481_GENE1.WRISVC_TG_KEI_TENDYMD >= :OPEDATE
            AND KK0481_GENE1.MK_FLG                 = '0'
        GROUP BY
             KK0481_GENE1.WRIB_SVC_KEI_NO
            ,KK0481_GENE1.WRIB_SVC_TRGT_KEI_NO
    )