APPS.ARP_PROCESS_PAYINFO dependencies on RA_CUSTOMER_TRX_LINES

Line 72: FROM ra_customer_trx_lines l, ra_interface_errors e

68: AND inv.payment_attributes IS NOT NULL
69: AND inv.paying_customer_id = cus.cust_account_id
70: AND NOT EXISTS (
71: SELECT /*+ leading(L) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 1
72: FROM ra_customer_trx_lines l, ra_interface_errors e
73: WHERE l.customer_trx_id = inv.customer_trx_id
74: AND l.customer_trx_line_id = e.interface_line_id
75: AND l.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- 7039838
76:

Line 119: ra_customer_trx_lines line

115: DISTINCT line.payment_trxn_extension_id
116: BULK COLLECT INTO
117: l_ext_entity_tab
118: FROM
119: ra_customer_trx_lines line
120: WHERE
121: line.customer_trx_id = c01_rec.customer_trx_id
122: AND line.line_type = 'LINE'
123: AND line.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- 7039838

Line 219: ra_customer_trx_lines lines

215: customer_trx_line_id,
216: l_msg,
217: payment_trxn_extension_id
218: FROM
219: ra_customer_trx_lines lines
220: WHERE
221: lines.customer_trx_id = c01_rec.customer_trx_id ;
222:
223: --