APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 2256: FROM ar_cash_receipt_history_all

2252:
2253: -- Bug 2606958 Start
2254: Cursor Receivables_Exists is
2255: SELECT 'Y'
2256: FROM ar_cash_receipt_history_all
2257: WHERE cash_receipt_history_id = to_number(l_cash_receipt_hist_id);
2258:
2259: Cursor Receivables_Applications is
2260: SELECT cash_receipt_history_id

Line 2266: FROM ar_cash_receipt_history_all

2262: WHERE receivable_application_id = to_number(l_cash_receipt_hist_id);
2263:
2264: Cursor Receivables_Hist is
2265: SELECT 'Y'
2266: FROM ar_cash_receipt_history_all
2267: WHERE cash_receipt_history_id = to_number(l_cash_receipt_hist_id);
2268:
2269:
2270: Cursor Receivables_History is

Line 2272: FROM ar_cash_receipt_history_all

2268:
2269:
2270: Cursor Receivables_History is
2271: SELECT 'Y', creation_date, created_by
2272: FROM ar_cash_receipt_history_all
2273: WHERE reversal_cash_receipt_hist_id = to_number(l_cash_receipt_hist_id);
2274:
2275: Cursor Receivables_Misc is
2276: SELECT 'Y', creation_date, created_by

Line 2571: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All ... REVERSAL');

2567:
2568: IF (l_rev_exists = 'Y')
2569: THEN
2570: IF (l_debug = 'Y') THEN
2571: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All ... REVERSAL');
2572: END IF;
2573: END IF;
2574: END IF;
2575:

Line 2599: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All: ' ||l_cash_receipt_hist_id);

2595:
2596: IF (l_rev_exists = 'Y')
2597: THEN
2598: IF (l_debug = 'Y') THEN
2599: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All: ' ||l_cash_receipt_hist_id);
2600: END IF;
2601:
2602: l_rev_exists := 'N';
2603:

Line 2604: -- Select the document info from Ar_Cash_Receipt_History_All table

2600: END IF;
2601:
2602: l_rev_exists := 'N';
2603:
2604: -- Select the document info from Ar_Cash_Receipt_History_All table
2605: OPEN Receivables_History;
2606: FETCH Receivables_History into l_rev_exists, l_doc_creation_date_d, l_doc_created_by_d;
2607: CLOSE Receivables_History;
2608: