Index: openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql	2 Feb 2006 11:52:15 -0000	1.1
+++ openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql	22 Jun 2006 08:27:12 -0000	1.2
@@ -20,4 +20,22 @@
       </querytext>
     </fullquery>
 
+    <fullquery name="get_all_uc_uos">
+      <querytext>
+        SELECT n.uos_code, n.uos_name, u.uos_id, u.unit_coordinator_id,
+	    s.short_name, s.pretty_name
+        FROM cc_uos u,
+	    cc_uos_name n,
+	    workflow_cases c,
+	    workflow_case_fsm f,
+	    workflow_fsm_states s
+	WHERE c.case_id = f.case_id
+	AND s.state_id = f.current_state
+	AND c.workflow_id = :workflow_id
+	AND u.uos_id = c.object_id
+	AND u.unit_coordinator_id = :user_id
+	AND n.name_id = u.uos_name_id
+      </querytext>
+    </fullquery>
+
 </queryset>