my @trans_ids_to_consider = map { $_->id } @$invoices_for_advance_payment;
if (scalar @trans_ids_to_consider) {
my $query = sprintf 'DELETE FROM acc_trans WHERE memo LIKE ? AND trans_id IN (%s)', join ', ', ("?") x scalar @trans_ids_to_consider;
my @trans_ids_to_consider = map { $_->id } @$invoices_for_advance_payment;
if (scalar @trans_ids_to_consider) {
my $query = sprintf 'DELETE FROM acc_trans WHERE memo LIKE ? AND trans_id IN (%s)', join ', ', ("?") x scalar @trans_ids_to_consider;