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 120: ra_customer_trx_lines line

116: DISTINCT line.payment_trxn_extension_id
117: BULK COLLECT INTO
118: l_ext_entity_tab
119: FROM
120: ra_customer_trx_lines line
121: WHERE
122: line.customer_trx_id = c01_rec.customer_trx_id
123: AND line.payment_trxn_extension_id IS NOT NULL -- 9274573
124: AND line.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- 7039838

Line 220: ra_customer_trx_lines lines

216: customer_trx_line_id,
217: l_msg,
218: payment_trxn_extension_id
219: FROM
220: ra_customer_trx_lines lines
221: WHERE
222: lines.customer_trx_id = c01_rec.customer_trx_id ;
223:
224: p_error_count := SQL%ROWCOUNT;