/*------------------------------------------------------------
-- 料金検証-検証用割引適用対象契約抽出
-- 割引サービス契約スキーマのアンロード（継続分）
------------------------------------------------------------*/
SELECT
    KK0451.WRIB_SVC_KEI_NO
   ,KK0451.GENE_ADD_DTM
   ,KK0451.WRIB_SVC_KEI_STAT
   ,KK0451.RSV_APLY_YMD
   ,KK0451.PLAN_STAYMD
   ,KK0451.PLAN_ENDYMD
   ,KK0451.PLAN_CHRG_STAYMD
   ,KK0451.PLAN_CHRG_ENDYMD
   ,KK0451.PLAN_END_SBT_CD
   ,KK0451.SVC_CANCEL_YMD
   ,NVL(KK0451.WRIB_AMNT_SNST_STDARDYMD,KK0451.SVC_STA_YMD)
   ,KK0451.SVC_CHRG_STAYMD
   ,KK0451.SVC_ENDYMD
   ,KK0451.SVC_CHRG_ENDYMD
   ,KK0451.SVC_DSL_YMD
   ,KK0451.SVC_DLRE_CD
   ,KK0451.KAIHK_YMD
   ,KK0451.PNLTY_HASSEI_CD
   ,KK0451.IDO_DIV
   ,KK0451.WRIB_SVC_CD
   ,KK0451.PCRS_CD
   ,KK0451.PPLAN_CD
FROM
    KK_T_WRIB_SVC_KEI KK0451
WHERE
        KK0451.RSV_APLY_YMD    <= ':PRC_CALC_YMD'
    AND KK0451.RSV_APLY_YMD    >= ':SEIKY_YM_SYONICHI'
    AND KK0451.RSV_APLY_CD     = '2'
    AND KK0451.MK_FLG  = '0'