Index: openacs-4/packages/invoices/tcl/invoice-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/tcl/invoice-procs.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/invoices/tcl/invoice-procs.xql 11 Oct 2005 15:23:28 -0000 1.2 +++ openacs-4/packages/invoices/tcl/invoice-procs.xql 23 Oct 2005 18:27:17 -0000 1.3 @@ -1,12 +1,12 @@ - + update iv_invoices set status = :status - where offer_id = (select latest_revision + where invoice_id = (select latest_revision from cr_items where item_id = :invoice_id)