Index: openacs-4/packages/dotlrn/www/admin/class-instance-new-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/Attic/class-instance-new-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/www/admin/class-instance-new-oracle.xql	1 May 2002 01:19:47 -0000	1.5
+++ openacs-4/packages/dotlrn/www/admin/class-instance-new-oracle.xql	16 May 2002 13:29:15 -0000	1.6
@@ -3,25 +3,12 @@
 <queryset>
     <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-    <fullquery name="select_class_info">
-        <querytext>
-            select pretty_name as class_name,
-                   description as class_description
-            from dotlrn_classes_full
-            where class_key = :class_key
-        </querytext>
-    </fullquery>
-
     <fullquery name="select_terms_for_select_widget">
         <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
-            and not exists (select 1
-                            from dotlrn_class_instances
-                            where dotlrn_class_instances.class_key = :class_key
-                            and dotlrn_class_instances.term_id = dotlrn_terms.term_id)
             order by dotlrn_terms.start_date
         </querytext>
     </fullquery>