my $join_cust_bill_pkg = 'LEFT JOIN cust_bill_pkg USING ( billpkgnum';
if ( $cgi->param('iscredit') eq 'rate' ) {
- $join_pkg .= ', billpkgtaxratelocationnum )';
+ $join_cust_bill_pkg .= ', billpkgtaxratelocationnum )';
} elsif ( $conf->exists('tax-pkg_address') ) {
- $join_pkg .= ', billpkgtaxlocationnum )';
+ $join_cust_bill_pkg .= ', billpkgtaxlocationnum )';
push @where, "billpkgtaxratelocationnum IS NULL";
} else {
- $join_pkg .= ' )';
+ $join_cust_bill_pkg .= ' )';
push @where, "billpkgtaxratelocationnum IS NULL";
}