Index: openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql,v
diff -u -r1.25 -r1.25.2.1
--- openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql	12 Jul 2004 14:49:56 -0000	1.25
+++ openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql	27 Dec 2005 21:50:53 -0000	1.25.2.1
@@ -116,4 +116,16 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="dotlrn_community::send_member_email.member_email">
+        <querytext>
+            select from_addr,
+	           subject,
+               email
+            from dotlrn_member_emails
+            where (enabled_p='t' or :override_enabled_p = 1)
+	          and community_id = :community_id
+	          and type = :type
+		</querytext>
+	</fullquery>
+
 </queryset>