APPS.ARP_TRX_VALIDATE dependencies on RA_INTERFACE_LINES

Line 313: ra_interface_lines ril

309: AND NVL(ri.new_customer_trx_id, -98) <> NVL(p_customer_trx_id, -99)
310: UNION
311: SELECT 'Y' -- already exists in the interface table
312: FROM ra_batch_sources bs,
313: ra_interface_lines ril
314: WHERE ril.batch_source_name = bs.name
315: AND bs.batch_source_id = p_batch_source_id
316: AND ril.trx_number = p_trx_number
317: AND ril.customer_trx_id <> NVL(p_customer_trx_id, -99);

Line 434: ra_interface_lines ril

430: <> NVL(p_customer_trx_id, -99)
431: UNION
432: SELECT 'Y'
433: FROM ra_cust_trx_types ctt,
434: ra_interface_lines ril
435: WHERE ril.cust_trx_type_name = ctt.name(+)
436: AND NVL(ril.cust_trx_type_id,
437: ctt.cust_trx_type_id) = p_cust_trx_type_id
438: AND ril.document_number = p_doc_sequence_value