APPS.FV_1219_TRANSACTIONS dependencies on AR_CASH_RECEIPTS_ALL

Line 2603: FROM Ar_Cash_Receipts_All

2599: THEN
2600: BEGIN
2601: SELECT 'Y'
2602: INTO l_exists
2603: FROM Ar_Cash_Receipts_All
2604: WHERE cash_receipt_id = to_number(l_cash_receipt_id)
2605: AND org_id = p_def_org_id;
2606:
2607: IF (FND_LOG.LEVEL_STATEMENT >=

Line 2611: ' EXISTS IN AR_CASH_RECEIPTS_ALL.');

2607: IF (FND_LOG.LEVEL_STATEMENT >=
2608: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2610: l_module_name,' CASH RECEIPT ID ' ||
2611: ' EXISTS IN AR_CASH_RECEIPTS_ALL.');
2612: END IF;
2613: EXCEPTION
2614: WHEN NO_DATA_FOUND THEN
2615: l_name := 'MANUAL';

Line 2621: 'AR_CASH_RECEIPTS_ALL, ' ||

2617: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2618: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2619: l_module_name,' NO_DATA_FOUND'
2620: || 'WHEN SELECTING FROM '||
2621: 'AR_CASH_RECEIPTS_ALL, ' ||
2622: ' HENCE MANUAL');
2623: END IF;
2624:
2625: WHEN INVALID_NUMBER OR VALUE_ERROR THEN

Line 2864: ar_cash_receipts_all acr,

2860: BEGIN
2861: SELECT cba.agency_location_code
2862: INTO l_temp_alc_code
2863: FROM ce_bank_accounts cba,
2864: ar_cash_receipts_all acr,
2865: ce_bank_acct_uses_all cbau
2866: WHERE acr.cash_receipt_id = l_cash_receipt_id --l_reference_2
2867: AND acr.remit_bank_acct_use_id = cbau.bank_acct_use_id
2868: AND cba.bank_account_id = cbau.bank_account_id

Line 3229: FROM ar_cash_receipts_all

3225:
3226: BEGIN
3227: SELECT DECODE(l_exists,'N',deposit_date,reversal_date)
3228: INTO l_accomplish_date
3229: FROM ar_cash_receipts_all
3230: WHERE cash_receipt_id = l_cash_receipt_id
3231: ANd org_id = p_def_org_id;
3232:
3233: EXCEPTION