DBA Data[Home] [Help]

APPS.OZF_CLAIM_SETTLEMENT_WF_PVT dependencies on RA_CUSTOMER_TRX

Line 311: FROM ra_customer_trx cust

307: , cust.trx_number --"settlement_number"
308: , cust.trx_date --"settlement_date"
309: , pay.amount_due_original --"settlement_amount"
310: , pay.status --"status_code"
311: FROM ra_customer_trx cust
312: , ar_payment_schedules pay
313: WHERE cust.complete_flag = 'Y'
314: AND cust.customer_trx_id = pay.customer_trx_id
315: AND cust.interface_header_attribute1 = cv_claim_number;