From d0a768c8d1d03468892c12ee0224f70c1586d9aa Mon Sep 17 00:00:00 2001 From: einhverfr Date: Thu, 7 Aug 2008 23:06:25 +0000 Subject: Correcting get_billing_info function git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2241 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Company.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index 45eebee7..ec530841 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -267,8 +267,8 @@ BEGIN a.city, a.state, a.mail_code, cc.name into out_var FROM company c - JOIN company eca ON (eca.entity_id = c.entity_id) - JOIN company_to_location cl ON (eca.id = cl.credit_id) + JOIN entity_credit_account eca ON (eca.entity_id = c.entity_id) + JOIN eca_to_location cl ON (eca.id = cl.credit_id) JOIN location a ON (a.id = cl.location_id) JOIN country cc ON (cc.id = a.country_id) WHERE eca.id = in_id AND location_class = 1; -- cgit v1.2.3