SELECT
    KK0451.WRIB_SVC_KEI_NO
    ,TO_CHAR(TO_DATE(KK0451.SVC_ENDYMD,'YYYYMMDD'),'YYYY/MM/DD')
FROM
    KK_T_WRIB_SVC_KEI KK0451
WHERE
    KK0451.RSV_APLY_YMD || KK0451.GENE_ADD_DTM =
    (
        SELECT
            MAX(KK0451_GENE.RSV_APLY_YMD || KK0451_GENE.GENE_ADD_DTM) AS KK0451_MAX
        FROM
            KK_T_WRIB_SVC_KEI KK0451_GENE
        WHERE
            KK0451_GENE.WRIB_SVC_KEI_NO = KK0451.WRIB_SVC_KEI_NO
            AND KK0451_GENE.RSV_APLY_YMD <= :OPEDATE
            AND KK0451_GENE.RSV_APLY_CD = '2'
            AND KK0451_GENE.MK_FLG = '0'
    )
AND KK0451.WRIB_SVC_CD = 'W00000006'
AND KK0451.SYSID IN (
        SELECT CN0071.SYSID
        FROM
            CN_T_CONT_CRECA_CHRG CN0071
        WHERE
            CN0071.CONT_SVC_CD IN (:CONT_SVC_CD_LIST)
        AND CN0071.CHRG_TRAN_YMD >= :TRGT_PRD_STAYMD
        AND CN0071.CHRG_TRAN_YMD <= :TRGT_PRD_ENDYMD
        AND CN0071.CHRG_STAT_CD = '0'
        AND CN0071.MK_FLG = '0'
        UNION
        SELECT CN0081.SYSID
        FROM
            CN_T_CONT_ISP_CHRG CN0081
        WHERE
            CN0081.CONT_SVC_CD IN (:CONT_SVC_CD_LIST)
        AND CN0081.CHRG_TRAN_YMD >= :TRGT_PRD_STAYMD 
        AND CN0081.CHRG_TRAN_YMD <= :TRGT_PRD_ENDYMD
        AND CN0081.CHRG_STAT_CD = '0'
        AND CN0081.MK_FLG = '0'
    )