Index: openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-add-edit-postgresql.xql,v
diff -u -r1.17 -r1.18
--- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	30 Apr 2004 19:14:51 -0000	1.17
+++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	14 May 2004 23:08:57 -0000	1.18
@@ -30,6 +30,7 @@
   <fullquery name="get_old_tasks">
     <querytext>
         select
+        t.parent_id as my_project_item_id,
         t.task_revision_id,
         t.title as my_task_title,
         t.description as my_description,
@@ -76,40 +77,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="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
-      SELECT
-        r.item_id, 
-        r.title as task_title        
-	FROM
-        pm_tasks_revisionsx r, 
-        cr_items i,
-        pm_tasks t
-        WHERE
-        r.parent_id = :project_item_id and
-        r.revision_id = i.live_revision and
-        i.item_id = t.task_id and
-        t.task_id in ([join $my_dependencies ","])        
-     ORDER BY
-     task_title
-    </querytext>
-  </fullquery>
-
   <fullquery name="get_task_item_id">
     <querytext>
       select