>>try
>>

>>
>>* the data space
>>SELECT Trans1.cTrans_pk ;
>>, MAX(Trans.yReferral_balance_amount) yReferral_balance_amount;
>>, MAX(Trans.yCurrent_balance_amount) yCurrent_balance_amount  ;
>>, SUM(Payments.yAmount_Paid) as yTotalPayments  ;
>>FROM Trans LEFT JOIN Payments ;
>>ON Payments.cTrans_fk = Trans1.cTrans_pk ;
>>   AND Payments.dPosting_date > Trans.tDate_received;
>>WHERE Trans.cResolution_Codes_fk is NULL ;
>>GROUP BY 1;
> having yCurrent_balance_amount <> yRefferal_Balance_amount - nvl(yTotalPayments,0)
>>into cursor curBalances
>>

>
>Would this work?
>
>Thanks a lot for your idea. It's much simpler that I have.

No, doesn't work with HAVING clause.