APPS.ARP_PROGRAM_BR_REMIT dependencies on RA_CUSTOMER_TRX

Line 1081: FROM ra_customer_trx br,

1077: br.drawee_id,
1078: br.drawee_site_use_id,
1079: br.payment_trxn_extension_id,
1080: pr.home_country
1081: FROM ra_customer_trx br,
1082: hz_cust_accounts hca,
1083: hz_parties party,
1084: /* Need to pass country code for SEPA specific receipts */
1085: ce_bank_acct_uses bau,

Line 1252: update ra_customer_trx

1248: into l_auth_id
1249: from IBY_TRXN_EXT_AUTHS_V
1250: where TRXN_EXTENSION_ID = l_trxn_entity_id;
1251:
1252: update ra_customer_trx
1253: set approval_code = 'AR'||to_char(l_auth_id)
1254: where customer_trx_id = br_rem_info.customer_trx_id ;
1255:
1256:

Line 1327: update ra_customer_trx

1323:
1324: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1325: -- update trx record with authorization code
1326:
1327: update ra_customer_trx
1328: set approval_code = l_authresult_rec.Auth_code ||'AR'||to_char(l_authresult_rec.Auth_Id)
1329: where customer_trx_id = br_rem_info.customer_trx_id ;
1330:
1331: IF PG_DEBUG in ('Y', 'C') THEN