- 'addl_from' => ' LEFT JOIN cust_credit_bill USING creditbillnum '.
- ' LEFT JOIN cust_bill_pkg USING billpkgnum ',
- 'hashref' => { 'invnum' => $self->invnum,
- 'pkgnum' => $pkgnum,
- },
+ '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",