Correction for Revenue Assurance Data in CollectProcessAudit Trigger

For CollectProcessAuditForIREL we experimented an error in the CDR quantity by batch_id. The issue is because the trigger consider each balance impact with amount > 0. So, this logic don't consider the with charge = 0 events, and consider more than once time the events with more than one bal impact. To solve this issue we changed the query OOB that the trigger use for this another:

                Select sum(amount) amount,

                nvl(batch_id, '') batch_id,

                min(decode(batch_id,original_batch_id,0,1)) batch_type,

                count(batch_id) Qty

        From (select sum(amount) amount, original_batch_id, poid_id0, batch_id from event_bal_impacts_t b,