Index: openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql	29 Jan 2003 15:41:25 -0000	1.8
+++ openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql	1 May 2003 20:40:53 -0000	1.9
@@ -177,5 +177,15 @@
       </querytext>
 </fullquery>
 
+<fullquery name="apm_application_new_checkbox.package_types">
+      <querytext>
+        select package_key, pretty_name
+        from apm_package_types
+        where not (apm_package.singleton_p(package_key) = 1 and
+                   apm_package.num_instances(package_key) >= 1)
+        order by pretty_name
+      </querytext>
+</fullquery>
+
  
 </queryset>