APPS.AR_RECEIPT_VAL_PVT dependencies on AR_RECEIVABLES_TRX

Line 2903: from ar_receivables_trx rt

2899: l_functional_currency ar_cash_receipts.currency_code%TYPE;
2900:
2901: cursor activity_type is
2902: select type
2903: from ar_receivables_trx rt
2904: where receivables_trx_id = p_receivables_trx_id;
2905:
2906: BEGIN
2907:

Line 3509: FROM ar_receivables_trx rt

3505: --CC Chargeback logic
3506: BEGIN
3507: SELECT rt.default_acctg_distribution_set
3508: INTO p_distribution_set_id
3509: FROM ar_receivables_trx rt
3510: WHERE rt.receivables_trx_id = p_receivables_trx_id
3511: AND rt.type in
3512: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND','CC_CHARGEBACK')
3513: AND nvl(rt.status, 'A') = 'A'

Line 3985: l_activity_name ar_receivables_trx.name%TYPE;

3981: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3982: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3983: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3984: l_func_currency gl_sets_of_books.currency_code%TYPE;
3985: l_activity_name ar_receivables_trx.name%TYPE;
3986: l_ccid NUMBER;
3987:
3988: BEGIN
3989:

Line 3998: FROM ar_receivables_trx

3994: -- Bug 3235089: checks for activity existing and accounting set up
3995: BEGIN
3996: SELECT name, code_combination_id
3997: INTO l_activity_name, l_ccid
3998: FROM ar_receivables_trx
3999: WHERE receivables_trx_id = -16;
4000:
4001: IF l_ccid IS NULL THEN
4002: FND_MESSAGE.SET_NAME('AR','AR_RW_NO_NETTING_ACCOUNT');