Index: openacs-4/packages/curriculum-central/www/coordinate/uos-all-pending-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/coordinate/uos-all-pending-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/curriculum-central/www/coordinate/uos-all-pending-postgresql.xql	18 Dec 2005 13:28:22 -0000	1.1
+++ openacs-4/packages/curriculum-central/www/coordinate/uos-all-pending-postgresql.xql	2 Feb 2006 11:45:49 -0000	1.2
@@ -5,9 +5,10 @@
 
     <fullquery name="get_all_pending_uos">
       <querytext>
-        SELECT u.uos_code, u.uos_name, u.uos_id, u.unit_coordinator_id,
+        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
@@ -16,6 +17,7 @@
 	AND c.workflow_id = :workflow_id
 	AND u.uos_id = c.object_id
 	AND s.short_name != 'closed'
+	AND n.name_id = u.uos_name_id
       </querytext>
     </fullquery>