APPS.ARP_PROCESS_PAYINFO dependencies on RA_CUSTOMER_TRX

Line 65: ra_customer_trx inv, hz_cust_accounts cus

61: inv.paying_customer_id,
62: inv.paying_site_use_id,
63: inv.org_id
64: FROM
65: ra_customer_trx inv, hz_cust_accounts cus
66: WHERE
67: inv.request_id = fnd_global.conc_request_id
68: AND inv.payment_attributes IS NOT NULL
69: AND inv.paying_customer_id = cus.cust_account_id

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: --

Line 233: ra_customer_trx

229: --
230: IF l_return_status = 'S' THEN
231: --
232: UPDATE
233: ra_customer_trx
234: SET
235: payment_trxn_extension_id = l_extension_id
236: WHERE
237: customer_trx_id = c01_rec.customer_trx_id;