my @where = ();
push @where, "cust_bill_pkg.invnum = ". $cust_bill->invnum;
push @where, "cust_bill_pkg.pkgpart_override IS NULL";
my @where = ();
push @where, "cust_bill_pkg.invnum = ". $cust_bill->invnum;
push @where, "cust_bill_pkg.pkgpart_override IS NULL";
push @where, "(cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0)";
push @where, "(cust_pkg.susp IS NULL OR cust_pkg.susp = 0)";
push @where, "0<(SELECT count(*) FROM part_pkg_discount
push @where, "(cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0)";
push @where, "(cust_pkg.susp IS NULL OR cust_pkg.susp = 0)";
push @where, "0<(SELECT count(*) FROM part_pkg_discount