my($self, $cust_bill) = @_;
my $servicenum = $self->option('has_service');
- grep { $servicenum == $_->svcnum }
+ grep { $servicenum == $_->svcpart }
map { $_->cust_pkg->cust_svc }
$cust_bill->cust_bill_pkg ;
}
FROM cust_bill_pkg cbp, cust_svc cs
WHERE cbp.invnum = cust_bill.invnum
AND cs.pkgnum = cbp.pkgnum
- AND cs.svcpart = $servicenum
+ AND cs.svcpart = CAST( $servicenum AS integer )
)
|;
return $sql;