APPS.AR_INVOICE_UTILS dependencies on RA_RECUR_INTERIM

Line 1404: FROM ra_recur_interim ri,

1400: AND nvl(batch.copy_doc_number_flag,'N') = 'N'
1401: AND nvl(batch.allow_duplicate_trx_num_flag,'N') = 'N'
1402: UNION
1403: SELECT 'X'
1404: FROM ra_recur_interim ri,
1405: ra_customer_trx ct,
1406: ra_batch_sources batch
1407: WHERE ct.customer_trx_id = ri.customer_trx_id
1408: AND ct.batch_source_id = gt.batch_source_id

Line 4926: FROM ra_recur_interim ri,

4922: WHERE gt.cust_trx_type_id IS NOT NULL
4923: AND gt.doc_sequence_value IS NOT NULL
4924: AND EXISTS (
4925: SELECT 'Y' --already exists
4926: FROM ra_recur_interim ri,
4927: ra_customer_trx ct
4928: WHERE ct.customer_trx_id = ri.customer_trx_id
4929: AND ct.cust_trx_type_id = gt.cust_trx_type_id
4930: AND ri.doc_sequence_value = gt.doc_sequence_value