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.1 -r1.2
--- openacs-4/packages/invoices/www/invoice-ae.xql	16 Aug 2005 20:04:34 -0000	1.1
+++ openacs-4/packages/invoices/www/invoice-ae.xql	6 Sep 2005 23:01:24 -0000	1.2
@@ -62,10 +62,10 @@
       <querytext>
 
     select p.first_names || ' ' || p.last_name, p.person_id
-    from persons p, pm_projects pj, cr_items i
+    from persons p, pm_projects pj, cr_items i, pm_project_assignment a
     where i.item_id in ([join $project_id ,])
     and i.latest_revision = pj.project_id
-    and pj.recipient_id = p.person_id
+    and p.person_id in ( select party_id from pm_project_assignment where project_id in ([join $project_id ,]))
     order by lower(p.last_name), lower(p.first_names)
 
       </querytext>