Index: openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/task-procs-postgresql.xql,v
diff -u -r1.4.2.5 -r1.4.2.6
--- openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	26 Oct 2004 01:22:27 -0000	1.4.2.5
+++ openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	26 Oct 2004 15:02:53 -0000	1.4.2.6
@@ -130,6 +130,28 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="pm::task::options_list.get_dependency_tasks">
+    <querytext>
+      SELECT
+        r.item_id, 
+        r.title as task_title        
+	FROM
+        pm_tasks_revisionsx r, 
+        cr_items i,
+        pm_tasks t,
+        pm_task_status s
+        WHERE
+        r.parent_id = :project_item_id and
+        r.revision_id = i.live_revision and
+        i.item_id = t.task_id and
+        t.status  = s.status_id and
+        s.status_type = 'o'
+      $union_clause
+     ORDER BY
+     task_title
+    </querytext>
+  </fullquery>
+
   <fullquery name="pm::task::options_list_html.get_dependency_tasks">
     <querytext>
       SELECT