APPS.ARP_PROCESS_CHARGEBACK dependencies on AR_RECEIVABLES_TRX

Line 1237: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;

1233: l_error_message VARCHAR2(128);
1234: l_defaulting_rule_used VARCHAR2(50);
1235: l_default_gl_date DATE;
1236: error_defaulting_gl_date EXCEPTION;
1237: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
1238: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

Line 1738: FROM ar_receivables_trx rt

1734: arp_standard.debug( '-- Get CB_ADJ activity accounting code combination');
1735: END IF;
1736: SELECT rt.code_combination_id
1737: INTO l_cb_activity_ccid
1738: FROM ar_receivables_trx rt
1739: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID
1740: AND rt.code_combination_id IS NOT NULL;
1741: EXCEPTION
1742: WHEN NO_DATA_FOUND THEN

Line 1747: arp_standard.debug( '-- Exception: select from ar_receivables_trx');

1743: FND_MESSAGE.set_name('AR', 'AR_RW_NO_GL_ACCT' );
1744: app_exception.raise_exception;
1745: WHEN OTHERS THEN
1746: IF PG_DEBUG in ('Y', 'C') THEN
1747: arp_standard.debug( '-- Exception: select from ar_receivables_trx');
1748: END IF;
1749: END;
1750:
1751: l_ctlgd_row.code_combination_id := l_cb_activity_ccid;

Line 2033: FROM ar_receivables_trx rt

2029: THEN
2030: -- Set up sequential numbering stuff
2031: SELECT rt.name
2032: INTO l_rec_name
2033: FROM ar_receivables_trx rt
2034: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID;
2035:
2036:
2037: -- Bug 686025/694300: instead of calling GET_SEQ_NAME, use