APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 2261: FROM ar_receivable_applications_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
2261: FROM ar_receivable_applications_all
2262: WHERE receivable_application_id = to_number(l_cash_receipt_hist_id);
2263:
2264: Cursor Receivables_Hist is
2265: SELECT 'Y'

Line 2386: FROM ar_receivable_applications_all

2382: WHERE adjustment_id = p_refer2;
2383:
2384: Cursor Receivables_CMA is
2385: SELECT apply_date, creation_date, created_by
2386: FROM ar_receivable_applications_all
2387: WHERE receivable_application_id = p_refer2;
2388:
2389: Cursor Receivables_Memos_Inv is
2390: SELECT trx_date, creation_date, created_by

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

2584: THEN
2585: l_cash_receipt_hist_id := l_temp_cr_hist_id;
2586:
2587: IF (l_debug = 'Y') THEN
2588: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Receivable_Applications_All: ' ||l_cash_receipt_hist_id);
2589: END IF;
2590:
2591: -- Use cash_receipt_history_id obtained above to find if a row exits in Ar_Cash_Receipts_All
2592: OPEN Receivables_Exists;