#-----------------------------------------------------------
#--料金プラン固定単価(KK_M_PPLAN_KTTANKA-KK_SELECT_001)
#--KKPRC39601
#--料金プラン固定金額を取得します。
#-----------------------------------------------------------

--KEY:KK_SELECT_001

SELECT
    PCRS_CD,
    PPLAN_CD,
    PPLAN_KOTEI_AMNT
FROM
    KK_M_PPLAN_KTTANKA KK0601
WHERE
    KK0601.PCRS_CD = ?
    AND KK0601.PPLAN_CD = ?
    AND KK0601.PPLAN_PRC_SBT_CD = '00'
    AND ? BETWEEN KK0601.PPLAN_KOTEI_TANKA_TSTAYMD AND KK0601.PPLAN_KOTEI_TANKA_TENDYMD
    AND (KK0601.PCRS_CD, KK0601.RSV_APLY_YMD || KK0601.GENE_ADD_DTM) =
     (SELECT KK0601_GENE.PCRS_CD, MAX(KK0601_GENE.RSV_APLY_YMD || KK0601_GENE.GENE_ADD_DTM) AS KK0601_MAX
      FROM KK_M_PPLAN_KTTANKA KK0601_GENE 
      WHERE KK0601_GENE.PCRS_CD = KK0601.PCRS_CD
      AND   KK0601_GENE.PPLAN_CD = KK0601.PPLAN_CD
      AND   KK0601_GENE.RSV_APLY_YMD <= ?
      AND   KK0601_GENE.MK_FLG = '0'
 GROUP BY KK0601_GENE.PCRS_CD)

#-

#-----------------------------------------------------------
#--料金プラン固定単価(KK_M_PPLAN_KTTANKA-KK_SELECT_002)
#--KKPRC02204
#--料金プラン固定単価の存在チェック
#-----------------------------------------------------------

--KEY:KK_SELECT_002

SELECT
    PCRS_CD,
    PPLAN_CD,
    PPLAN_KOTEI_AMNT
FROM
    KK_M_PPLAN_KTTANKA KK0601
WHERE
    KK0601.PCRS_CD = ?
    AND KK0601.PPLAN_CD = ?
    AND KK0601.PPLAN_KOTEI_TANKA_TSTAYMD <= ? 
    AND KK0601.PPLAN_KOTEI_TANKA_TENDYMD >= ?
    AND KK0601.RSV_APLY_YMD || KK0601.GENE_ADD_DTM =
     (SELECT MAX(KK0601_GENE.RSV_APLY_YMD || KK0601_GENE.GENE_ADD_DTM) AS KK0601_MAX
      FROM KK_M_PPLAN_KTTANKA KK0601_GENE 
      WHERE KK0601_GENE.PCRS_CD = KK0601.PCRS_CD
      AND   KK0601_GENE.PPLAN_CD = KK0601.PPLAN_CD
      AND   KK0601_GENE.RSV_APLY_YMD <= ?
      AND   KK0601_GENE.MK_FLG = '0')

#-