SELECT A.tour_mst_amt
          , A.tour_sta_cd
          , substring(A.tour_day_st,1,7) as mm
          , A.gd_mst_pay_seq
          , A.tour_day_st
          , A.gd_mst_seq
FROM GD_MST_PAY A
WHERE A.gd_mst_seq = :gd_mst_seq
AND A.tour_day_st > :today
AND A.use_yn = 'Y'
ORDER BY A.tour_day_st