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.5 -r1.6
--- openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	27 Apr 2004 00:49:28 -0000	1.5
+++ openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	14 May 2004 23:08:56 -0000	1.6
@@ -74,6 +74,28 @@
     </querytext>
   </fullquery>
   
+  <fullquery name="pm::task::dependency_options.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::edit.new_task_revision">
     <querytext>
       select pm_task__new_task_revision (