>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.