X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fcust_bill.pm;h=08a74bc1f4bb8d11816c3a69d05f57eb2a4e6902;hp=dd8fab231fb58e63e3b0ce7f457cb10b2f18f3d9;hb=242170bb599b909f801144bfc814d5ee6d649c00;hpb=a1cde9ea31bf9f019ecf706efb158c2baa11efa7

diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm
index dd8fab231..08a74bc1f 100644
--- a/FS/FS/cust_bill.pm
+++ b/FS/FS/cust_bill.pm
@@ -683,8 +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 ) ',
-    'extra_sql' => ' WHERE invnum = '. $self->invnum.
-                   "   AND pkgnum = $pkgnum",
+    'extra_sql' => ' WHERE cust_bill_pkg.invnum = '. $self->invnum.
+                   "   AND cust_bill_pkg.pkgnum = $pkgnum",
   });
 
 }
@@ -727,8 +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    ) ',
-    'extra_sql' => ' WHERE invnum = '. $self->invnum.
-                   "   AND pkgnum = $pkgnum",
+    'extra_sql' => ' WHERE cust_bill_pkg.invnum = '. $self->invnum.
+                   "   AND cust_bill_pkg.pkgnum = $pkgnum",
   });
 
 }