1076: party.party_id,
1077: br.drawee_id,
1078: br.drawee_site_use_id,
1079: br.payment_trxn_extension_id
1080: FROM ra_customer_trx br,
1081: hz_cust_accounts hca,
1082: hz_parties party
1083: WHERE br.remittance_batch_id = p_batch_id
1084: and hca.party_id = party.party_id
1231: into l_auth_id
1232: from IBY_TRXN_EXT_AUTHS_V
1233: where TRXN_EXTENSION_ID = l_trxn_entity_id;
1234:
1235: update ra_customer_trx
1236: set approval_code = 'AR'||to_char(l_auth_id)
1237: where customer_trx_id = br_rem_info.customer_trx_id ;
1238:
1239:
1305:
1306: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1307: -- update trx record with authorization code
1308:
1309: update ra_customer_trx
1310: set approval_code = l_authresult_rec.Auth_code ||'AR'||to_char(l_authresult_rec.Auth_Id)
1311: where customer_trx_id = br_rem_info.customer_trx_id ;
1312:
1313: IF PG_DEBUG in ('Y', 'C') THEN