>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.
If it's not broken, fix it until it is.
My Blog 
