Index: openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql,v
diff -u -r1.4.2.1 -r1.4.2.2
--- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	29 Apr 2004 10:36:07 -0000	1.4.2.1
+++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	11 Nov 2004 06:39:55 -0000	1.4.2.2
@@ -198,7 +198,6 @@
          $more_columns
     from $from_bug_clause,
          acs_users_all submitter,
-         acs_users_all assignee,
          workflow_cases cas,
          workflow_case_fsm cfsm,
          workflow_fsm_states st 
@@ -217,15 +216,15 @@
           aa.action_id,
           aa.case_id,
           wa.pretty_name as action_pretty_name,
-          assignee.first_names as assignee_first_names,
-          assignee.last_name as assignee_last_name
+          p.first_names as assignee_first_names,
+          p.last_name as assignee_last_name
      from workflow_case_assigned_actions aa,
           workflow_case_role_user_map cru,
           workflow_actions wa,
-          acs_users_all assignee
+          persons p
     where aa.case_id = cru.case_id
       and aa.role_id = cru.role_id
-      and cru.user_id = assignee.user_id
+      and cru.user_id = p.person_id
       and wa.action_id = aa.action_id
   ) assign_info
 where q.bug_id = km.item_id (+)