DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on OZF_CLAIMS

Line 1255: ozf_claims ofc

1251: SELECT ps.amount_due_remaining-ofc.amount+p_adj_rec.amount,ofc.amount into v_cont,v_claim_amt ---Modified for the bug 14500887
1252: FROM ra_customer_trx rct,
1253: ar_payment_schedules ps,
1254: ar_receivable_applications ra,
1255: ozf_claims ofc
1256: WHERE rct.customer_trx_id=ps.customer_trx_id
1257: AND ra.applied_customer_trx_id=rct.customer_trx_id
1258: AND ofc.source_object_id = rct.customer_trx_id
1259: AND rct.customer_trx_id = p_adj_rec.customer_trx_id