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.3 -r1.4.2.4
--- openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	16 Sep 2004 18:25:36 -0000	1.4.2.3
+++ openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	23 Sep 2004 21:46:41 -0000	1.4.2.4
@@ -129,4 +129,25 @@
         :package_id)
     </querytext>
   </fullquery>
+
+  <fullquery name="pm::task::process_task_info.get_process_tasks">
+    <querytext>
+        SELECT
+        t.process_task_id as process_tid,
+        t.one_line,
+        t.description,
+        t.estimated_hours_work,
+        t.estimated_hours_work_min,
+        t.estimated_hours_work_max,
+        d.dependency_id,
+        d.parent_task_id as process_parent_task
+        FROM
+        pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id
+        WHERE
+        t.process_id = :process_id
+        ORDER BY
+        t.ordering,
+        t.process_task_id
+    </querytext>
+  </fullquery>
 </queryset>