APPS.AR_CM_API_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 558

SELECT ra.receivable_application_id,
       ra.customer_trx_id,
       ct.trx_number
from ar_receivable_applications ra, ra_customer_trx ct
where ra.posting_control_id=-3
and ra.application_type = 'CM'
and ra.customer_trx_id=p_customer_trx_id
and ra.event_id is null
and ra.customer_trx_id = ct.customer_trx_id;