Index: openacs-4/packages/invoices/www/invoice-cancellation.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/invoice-cancellation.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/invoices/www/invoice-cancellation.xql 27 Oct 2005 18:11:24 -0000 1.3 +++ openacs-4/packages/invoices/www/invoice-cancellation.xql 14 Dec 2005 22:06:38 -0000 1.4 @@ -27,11 +27,10 @@ select of.offer_id as credit_offer_rev_id - from iv_offers of, cr_items oi, acs_rels r, + from iv_offers of, cr_items oi, acs_data_links r, acs_objects o, pm_projects p, cr_items pi where r.object_id_one = pi.item_id and r.object_id_two = oi.item_id - and r.rel_type = 'application_data_link' and oi.latest_revision = of.offer_id and of.status = 'credit' and o.object_id = of.offer_id