fix package balance conditions, RT#11834

diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm
index 9f27a74..dd8fab2 100644 (file)
--- a/FS/FS/cust_bill.pm
+++ b/FS/FS/cust_bill.pm
@@ -683,9 +683,8 @@ sub 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 ) ',
     'table'     => 'cust_bill_pay_pkg',
     'addl_from' => ' LEFT JOIN cust_bill_pay USING ( billpaynum ) '.
                    ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ',

-    'hashref'   => { 'invnum' => $self->invnum,
-                     'pkgnum' => $pkgnum,
-                   },
+    'extra_sql' => ' WHERE invnum = '. $self->invnum.
+                   "   AND pkgnum = $pkgnum",

   });
 
 }
   });
 
 }


@@ -728,9 +727,8 @@ sub 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    ) ',
     'table'     => 'cust_credit_bill_pkg',
     'addl_from' => ' LEFT JOIN cust_credit_bill USING ( creditbillnum ) '.
                    ' LEFT JOIN cust_bill_pkg    USING ( billpkgnum    ) ',

-    'hashref'   => { 'invnum' => $self->invnum,
-                     'pkgnum' => $pkgnum,
-                   },
+    'extra_sql' => ' WHERE invnum = '. $self->invnum.
+                   "   AND pkgnum = $pkgnum",

   });
 
 }
   });
 
 }