APPS.AR_RECEIPT_VAL_PVT dependencies on AR_RECEIVABLES_TRX

Line 2774: from ar_receivables_trx rt

2770: l_functional_currency ar_cash_receipts.currency_code%TYPE;
2771:
2772: cursor activity_type is
2773: select type
2774: from ar_receivables_trx rt
2775: where receivables_trx_id = p_receivables_trx_id;
2776:
2777: BEGIN
2778:

Line 3372: FROM ar_receivables_trx rt

3368: --CC Chargeback logic
3369: BEGIN
3370: SELECT rt.default_acctg_distribution_set
3371: INTO p_distribution_set_id
3372: FROM ar_receivables_trx rt
3373: WHERE rt.receivables_trx_id = p_receivables_trx_id
3374: AND rt.type in
3375: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND','CC_CHARGEBACK')
3376: AND nvl(rt.status, 'A') = 'A'

Line 3847: l_activity_name ar_receivables_trx.name%TYPE;

3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3846: l_func_currency gl_sets_of_books.currency_code%TYPE;
3847: l_activity_name ar_receivables_trx.name%TYPE;
3848: l_ccid NUMBER;
3849:
3850: BEGIN
3851:

Line 3860: FROM ar_receivables_trx

3856: -- Bug 3235089: checks for activity existing and accounting set up
3857: BEGIN
3858: SELECT name, code_combination_id
3859: INTO l_activity_name, l_ccid
3860: FROM ar_receivables_trx
3861: WHERE receivables_trx_id = -16;
3862:
3863: IF l_ccid IS NULL THEN
3864: FND_MESSAGE.SET_NAME('AR','AR_RW_NO_NETTING_ACCOUNT');