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.8 -r1.4.2.9
--- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	23 Jan 2005 00:21:37 -0000	1.4.2.8
+++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	27 Jan 2005 02:29:32 -0000	1.4.2.9
@@ -75,62 +75,7 @@
         end;
     </querytext>
 </fullquery>
- 
 
-<fullquery name="bug_tracker::bug::get_list.select_categories">
-  <querytext>
-        select kw.heading,
-               km.keyword_id,
-               count(b.bug_id)
-        from   cr_keywords kw,
-               cr_item_keyword_map km,
-               bt_bugs b
-        where  kw.parent_id = :parent_id
-        and    km.keyword_id = kw.keyword_id
-        and    b.bug_id (+) = km.item_id
-        and    b.project_id = :package_id
-        group  by kw.heading, km.keyword_id
-        order  by kw.heading
-
-  </querytext>
-</fullquery>
-
-<fullquery name="bug_tracker::bug::get_list.select_fix_for_versions">
-  <querytext>
-
-        select v.version_name,
-               b.fix_for_version,
-               count(b.bug_id) as num_bugs
-        from   bt_bugs b,
-               bt_versions v
-        where  b.project_id = :package_id
-        and    v.version_id (+) = b.fix_for_version
-        group  by b.fix_for_version, v.anticipated_freeze_date, v.version_name
-        order  by v.anticipated_freeze_date, v.version_name
-
-  </querytext>
-</fullquery>
-
-<fullquery name="bug_tracker::bug::get_list.select_action_assignees">
-  <querytext>
-    select p.first_names || ' ' || p.last_name as name,
-           crum.user_id,
-           count(b.bug_id) as num_bugs
-    from   bt_bugs b,
-           workflow_case_assigned_actions aa,
-           workflow_case_role_user_map crum,
-           persons p
-    where  b.project_id = :package_id
-    and    aa.workflow_id = :workflow_id
-    and    aa.action_id = :action_id
-    and    aa.object_id = b.bug_id
-    and    crum.case_id (+) = aa.case_id
-    and    crum.role_id (+) = aa.role_id
-    and    p.person_id (+) = crum.user_id
-    group  by p.first_names, p.last_name, crum.user_id
-  </querytext>
-</fullquery>
-
   <partialquery name="bug_tracker::bug::get_list.category_where_clause">
       <querytext>
          content_keyword.is_assigned(b.bug_id, :f_category_$parent_id, 'none') = 't'