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.2 -r1.3 --- openacs-4/packages/invoices/www/invoice-ae.xql 6 Sep 2005 23:01:24 -0000 1.2 +++ openacs-4/packages/invoices/www/invoice-ae.xql 8 Sep 2005 18:30:50 -0000 1.3 @@ -62,7 +62,7 @@ select p.first_names || ' ' || p.last_name, p.person_id - from persons p, pm_projects pj, cr_items i, pm_project_assignment a + from persons p, pm_projects pj, cr_items i where i.item_id in ([join $project_id ,]) and i.latest_revision = pj.project_id and p.person_id in ( select party_id from pm_project_assignment where project_id in ([join $project_id ,]))