Index: openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql	27 Apr 2001 01:41:12 -0000	1.1
+++ openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql	13 Apr 2009 23:10:27 -0000	1.2
@@ -26,14 +26,16 @@
 </fullquery>
  
 <fullquery name="apm_specific_version_dependencies">      
-      <querytext>
-select t.pretty_name dep_pretty_name, v.version_name dep_version_name, v.version_id dep_version_id
-from apm_package_versions v, apm_package_dependencies d, apm_package_types t
-where d.service_uri = :service_uri
-and d.dependency_type = :other_dependency_type_prep
-and d.version_id = v.version_id
-and t.package_key = v.package_key 
-and apm_package_version.sortable_version_name(d.service_version) $sign apm_package_version.sortable_version_name(:service_version)
+  <querytext>
+    select t.pretty_name dep_pretty_name, v.version_name dep_version_name,
+      v.version_id dep_version_id, d.dependency_type as dep_type
+    from apm_package_versions v, apm_package_dependencies d, apm_package_types t
+    where d.service_uri = :service_uri
+      and d.dependency_type = in ($other_dependency_in)
+      and d.version_id = v.version_id
+      and t.package_key = v.package_key 
+      and apm_package_version.sortable_version_name(d.service_version)
+        $sign apm_package_version.sortable_version_name(:service_version)
       </querytext>
 </fullquery>