DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on RA_RECUR_INTERIM

Line 304: FROM ra_recur_interim ri,

300: AND trx_number = p_trx_number
301: AND customer_trx_id <> NVL(p_customer_trx_id, -99)
302: UNION
303: SELECT 'Y' -- already exists in the interim table
304: FROM ra_recur_interim ri,
305: ra_customer_trx ct
306: WHERE ct.customer_trx_id = ri.customer_trx_id
307: AND ct.batch_source_id = p_batch_source_id
308: AND ri.trx_number = p_trx_number

Line 424: FROM ra_recur_interim ri,

420: )
421: THEN
422: SELECT 'Y' --already exists
423: INTO l_temp
424: FROM ra_recur_interim ri,
425: ra_customer_trx ct
426: WHERE ct.customer_trx_id = ri.customer_trx_id
427: AND ct.cust_trx_type_id = p_cust_trx_type_id
428: AND ri.doc_sequence_value = p_doc_sequence_value