RT#33484 [actually a bug fix to d4b8e45c3589f3c6489442798f5fba439d5a29c9]
authorJonathan Prykop <jonathan@freeside.biz>
Tue, 9 Jun 2015 20:47:56 +0000 (15:47 -0500)
committerJonathan Prykop <jonathan@freeside.biz>
Tue, 9 Jun 2015 20:47:56 +0000 (15:47 -0500)
FS/FS/cust_main/Billing_Discount.pm

index b2852f6..117bf31 100644 (file)
@@ -47,7 +47,7 @@ sub _discount_pkgs_and_bill {
   push @where,
     "NOT EXISTS (
        SELECT 1 FROM cust_bill_pkg_discount
-         WHERE cust_bill_pkg.billpkgnum = cust_bill_pkg_discount.billpkgnu:
+         WHERE cust_bill_pkg.billpkgnum = cust_bill_pkg_discount.billpkgnum
     )";
 
   my $extra_sql = 'WHERE '. join(' AND ', @where);