$where_pkg .= <<END;
and 0 < ( select count(*) from cust_main
where cust_pkg.custnum = cust_main.custnum
- and cust_main.agentnum = $opt{a}
+ and cust_main.agentnum IN ( $opt{a} )
)
END
}
my $msg_template = qsearchs('msg_template', { msgnum => $msgnum });
$cust_main->setfield('packages', \\@packages);
$cust_main->setfield('recurdates', \\@recurdates);
- $error = $msg_template->send('cust_main' => $cust_main);
+ $error = $msg_template->send('cust_main' => $cust_main,
+ 'object' => $cust_main);
}
else {
$error = $cust_main->notify( 'impending_recur_template',