Index: openacs-4/packages/invoices/www/invoice-ae.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/invoice-ae.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/invoices/www/invoice-ae.xql	26 Oct 2005 12:00:38 -0000	1.6
+++ openacs-4/packages/invoices/www/invoice-ae.xql	17 Nov 2005 16:23:08 -0000	1.7
@@ -239,12 +239,22 @@
 
 <fullquery name="set_status">
       <querytext>
-
 		update iv_offers
 		set status = :status
 		where offer_id = :offer_id
-
       </querytext>
 </fullquery>
 
+<fullquery name="get_organizations">
+    <querytext>
+	select 
+		distinct 
+		customer_id 
+	from 
+		pm_projectsx 
+	where 
+		item_id in ([join $project_id ","])
+    </querytext>
+</fullquery>
+
 </queryset>