#-----------------------------------------------------------
#--割引段階(AC_M_WRIB_FLR-AC_SELECT_001)
#--UIA17_ACPRC00107_割引計算.xlsx　参照
#-----------------------------------------------------------

--KEY:AC_SELECT_001

SELECT
    AC0241.SYS_CD,
    AC0241.PCRS_CD,
    AC0241.PRC_SVC_CD,
    AC0241.AITAI_NO,
    AC0241.WRIB_SHUK_CD,
    AC0241.LOWL_VALUE,
    AC0241.UPPL_VALUE,
    AC0241.WRIB_FLR_CD
FROM
    AC_M_WRIB_FLR AC0241
WHERE
    AC0241.SYS_CD = ? AND
    ? BETWEEN
    AC0241.WRIB_FLR_TSTAYMD AND
    AC0241.WRIB_FLR_TENDYMD AND
    AC0241.MK_FLG = '0'

#-