Index: openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-procs-postgresql.xql,v
diff -u -r1.4.2.3 -r1.4.2.4
--- openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	16 Jul 2004 20:59:40 -0000	1.4.2.3
+++ openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	26 Oct 2004 01:22:27 -0000	1.4.2.4
@@ -45,6 +45,18 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="pm::project::log_hours.add_task_logger_map">
+    <querytext>
+      INSERT INTO
+      pm_task_logger_proj_map
+      (task_item_id,
+      logger_entry)
+      VALUES
+      (:task_item_id,
+      :entry_id)
+    </querytext>
+  </fullquery>
+
   <fullquery name="pm::project::new.new_project_item">
     <querytext>
         select pm_project__new_project_item (
@@ -200,4 +212,24 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="pm::project::get_list_of_open.get_vals">
+    <querytext>
+      SELECT
+      case when o.name is null then p.title else p.title || ' (' || o.name || ')' end,
+      p.item_id
+      FROM pm_projectsx p
+        LEFT JOIN 
+        organizations o
+        ON p.customer_id = o.organization_id,
+      cr_items i, 
+      pm_project_status s
+      WHERE 
+      p.project_id  = i.live_revision and
+      s.status_id   = p.status_id and
+      s.status_type = 'o'
+      ORDER BY
+      lower(p.title), lower(o.name) 
+    </querytext>
+  </fullquery>
+
 </queryset>