Index: openacs-4/packages/ecommerce/www/admin/customer-service/email-send.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/email-send.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/customer-service/email-send.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/customer-service/email-send.xql	31 Jan 2002 06:41:59 -0000	1.2
@@ -1,23 +1,12 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="get_user_information">
-      <querytext>
-
-select u.email as user_email, id.email as id_email
-  from ec_user_identification id
-  left join cc_users u using (user_id)
-  where id.user_identification_id=:user_identification_id
-
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="get_full_name">      
-      <querytext>
-      select first_names || ' ' || last_name from cc_users where user_id=:customer_service_rep
-      </querytext>
-</fullquery>
-
- 
+  <fullquery name="get_full_name">      
+    <querytext>
+      select first_names || ' ' || last_name 
+      from cc_users 
+      where user_id=:customer_service_rep
+    </querytext>
+  </fullquery>
+  
 </queryset>