>Naomi,
>
>>No, doesn't work with HAVING clause.
>
>Just in case, I would point out you have a spelling mistake in your having clause
>
>>>SELECT ... ;
>>>, MAX(Trans.yReferral_balance_amount) yReferral_balance_amount;
>>>...
>>>GROUP BY 1;
>> having yCurrent_balance_amount <> yRefferal_Balance_amount - nvl(yTotalPayments,0)
>>>into cursor curBalances

Should I give you the stars then? <g>

Thanks a lot, Hugo, it worked. Now I'm ashamed <g> I'm supposed to be a good speller. But I always mix referral f and r.