SELECT A.disp_seq
     , A.ref_seq
     , A.class_cd
     , A.title_1
     , A.title_2
     , A.title_3
     , A.banner_path
     , A.click_url
     , A.banner_width
     , A.banner_height
     , A.disp_desc
     , A.start_dt
     , A.end_dt
     , A.start_day
     , A.end_day
     , A.start_time
     , A.end_time
     , A.del_yn
     , A.disp_yn
     , A.disp_order
  FROM RA_DISP A
 WHERE A.disp_yn = 'Y'
 AND A.del_yn != 'Y'
 AND A.class_cd = 'RAMOBA001'
 AND A.ba_comp_seq = :login_comp_seq
 AND A.start_day <= :day AND A.end_day >= :day
 ORDER BY A.disp_order ASC