3270: SET recommendation_reason = 'AR_AA_MUL_APP_TRX'
3271: WHERE ( EXISTS (SELECT 'PS already Applied'
3272: FROM ar_cash_recos rec,
3273: ar_cash_remit_refs_interim ref,
3274: ar_receivable_applications ra
3275: WHERE rec.recommendation_id = l.recommendation_id
3276: AND ref.remit_reference_id = rec.remit_reference_id
3277: AND ra.cash_receipt_id = ref.cash_receipt_id
3278: AND ref.worker_number = p_worker_number