From d173c0ab4d47eea5fc0d76b9f8d94b7dc6a44cfb Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 30 Mar 2011 19:43:41 +0000
Subject: [PATCH] fix package balance conditions, RT#11834

---
 FS/FS/cust_bill.pm | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm
index f673b76a3..9f27a74ba 100644
--- a/FS/FS/cust_bill.pm
+++ b/FS/FS/cust_bill.pm
@@ -681,8 +681,8 @@ sub cust_bill_pay_pkg {
   qsearch({
     'select'    => 'cust_bill_pay_pkg.*',
     'table'     => 'cust_bill_pay_pkg',
-    'addl_from' => ' LEFT JOIN cust_bill_pay USING billpaynum '.
-                   ' LEFT JOIN cust_bill_pkg USING billpkgnum ',
+    'addl_from' => ' LEFT JOIN cust_bill_pay USING ( billpaynum ) '.
+                   ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ',
     'hashref'   => { 'invnum' => $self->invnum,
                      'pkgnum' => $pkgnum,
                    },
@@ -726,8 +726,8 @@ sub cust_credit_bill_pkg {
   qsearch({
     'select'    => 'cust_credit_bill_pkg.*',
     'table'     => 'cust_credit_bill_pkg',
-    'addl_from' => ' LEFT JOIN cust_credit_bill USING creditbillnum '.
-                   ' LEFT JOIN cust_bill_pkg    USING billpkgnum ',
+    'addl_from' => ' LEFT JOIN cust_credit_bill USING ( creditbillnum ) '.
+                   ' LEFT JOIN cust_bill_pkg    USING ( billpkgnum    ) ',
     'hashref'   => { 'invnum' => $self->invnum,
                      'pkgnum' => $pkgnum,
                    },
-- 
2.11.0