APPS.AR_INVOICE_UTILS dependencies on RA_RECUR_INTERIM

Line 1411: FROM ra_recur_interim ri,

1407: AND nvl(batch.copy_doc_number_flag,'N') = 'N'
1408: AND nvl(batch.allow_duplicate_trx_num_flag,'N') = 'N'
1409: UNION
1410: SELECT 'X'
1411: FROM ra_recur_interim ri,
1412: ra_customer_trx ct,
1413: ra_batch_sources batch
1414: WHERE ct.customer_trx_id = ri.customer_trx_id
1415: AND ct.batch_source_id = gt.batch_source_id

Line 5053: FROM ra_recur_interim ri,

5049: WHERE gt.cust_trx_type_id IS NOT NULL
5050: AND gt.doc_sequence_value IS NOT NULL
5051: AND EXISTS (
5052: SELECT 'Y' --already exists
5053: FROM ra_recur_interim ri,
5054: ra_customer_trx ct
5055: WHERE ct.customer_trx_id = ri.customer_trx_id
5056: AND ct.cust_trx_type_id = gt.cust_trx_type_id
5057: AND ri.doc_sequence_value = gt.doc_sequence_value