Index: openacs-4/packages/dotlrn/tcl/term-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/Attic/term-procs-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/tcl/term-procs-oracle.xql	1 May 2002 01:19:47 -0000	1.5
+++ openacs-4/packages/dotlrn/tcl/term-procs-oracle.xql	26 Jul 2002 02:01:34 -0000	1.6
@@ -46,4 +46,14 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="dotlrn_term::get_future_terms_as_options.get_future_terms_select">
+        <querytext>
+          select dotlrn_terms.term_name || ' ' || dotlrn_terms.term_year as term,
+                 dotlrn_terms.term_id
+          from dotlrn_terms
+          where dotlrn_terms.end_date > sysdate
+          order by dotlrn_terms.start_date
+        </querytext>
+    </fullquery>
+
 </queryset>