/*------------------------------------------------------------
-- お得情報作成（移行用）
-- 即割用に割引料金アンロード処理
------------------------------------------------------------*/
SELECT
  AC0251.WRIB_SHUK_CD
  ,AC0251.PCRS_CD
  ,AC0251.PRC_SVC_CD
  ,KK0711.PPLAN_CD
  ,TO_CHAR(AC0251.WRIB_VALUE)
  ,KK0711.WRIB_SVC_CD
FROM
  AC_M_WRIB_PRC AC0251
INNER JOIN
  KK_M_WRIB_SVC_TANKA KK0711
  ON  KK0711.PCRS_CD            = AC0251.PCRS_CD
  AND KK0711.WRIB_SVC_TANKA_NO  = AC0251.PRC_SVC_CD
WHERE
      KK0711.WRIB_SVC_CD        = 'W00000021'
  AND AC0251.WRIB_SHUK_CD       = '02'
  AND :SEIKY_ENDDAY BETWEEN KK0711.WRIB_SVC_TANKA_TSTAYMD AND KK0711.WRIB_SVC_TANKA_TENDYMD
  AND :SEIKY_ENDDAY BETWEEN AC0251.WRIB_PRC_TSTAYMD AND AC0251.WRIB_PRC_TENDYMD