/*------------------------------------------------------------
-- 料金検証-検証用割引適用対象契約抽出
-- サービス契約スキーマのアンロード
------------------------------------------------------------*/
SELECT
    KK0081.SVC_KEI_NO
   ,KK0081.RSV_APLY_YMD
   ,KK0081.GENE_ADD_DTM
   ,KK0081.SYSID
   ,nvl(KK0081.SEIRI_NO,'              ')
   ,KK0081.SVC_CD
   ,KK0081.PRC_GRP_CD
   ,KK0081.PCRS_CD
   ,KK0081.PPLAN_CD
   ,KK0081.PLAN_CHRG_ENDYMD
   ,KK0081.SVC_CHRG_ENDYMD
   ,KK0081.SVC_DSL_YMD
   ,KK0081.SVC_DLRE_CD
   ,KK0081.KAIHK_YMD
FROM
    KK_T_SVC_KEI KK0081
WHERE
        KK0081.PLAN_CHRG_STAYMD <= ':SEIKY_END_YMD'
    AND KK0081.RSV_APLY_YMD     <= ':PRC_CALC_YMD'
    AND KK0081.RSV_APLY_CD       = '2'
    AND KK0081.MK_FLG            = '0'