DBA Data[Home] [Help]

APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on AR_MISC_CASH_DISTRIBUTIONS_ALL

Line 2277: FROM ar_misc_cash_distributions_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
2277: FROM ar_misc_cash_distributions_all
2278: WHERE misc_cash_distribution_id = l_cash_receipt_hist_id
2279: AND created_from = 'ARP_REVERSE_RECEIPT.REVERSE';
2280:
2281: Cursor Receivables_Distrib is

Line 2283: FROM ar_misc_cash_distributions_all

2279: AND created_from = 'ARP_REVERSE_RECEIPT.REVERSE';
2280:
2281: Cursor Receivables_Distrib is
2282: SELECT 'Y'
2283: FROM ar_misc_cash_distributions_all
2284: WHERE misc_cash_distribution_id = to_number(l_cash_receipt_hist_id);
2285:
2286: -- Bug 2606958 End
2287:

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

2625:
2626: IF (l_rev_exists = 'Y')
2627: THEN
2628: IF (l_debug = 'Y') THEN
2629: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Misc_Cash_Distributions_All: ' ||l_cash_receipt_hist_id);
2630: END IF;
2631:
2632: l_rev_exists := 'N';
2633:

Line 2634: -- Select the document info from Ar_Misc_Cash_Distributions_All table

2630: END IF;
2631:
2632: l_rev_exists := 'N';
2633:
2634: -- Select the document info from Ar_Misc_Cash_Distributions_All table
2635: OPEN Receivables_Misc;
2636: FETCH Receivables_Misc into l_rev_exists, l_doc_creation_date_d, l_doc_created_by_d;
2637: CLOSE Receivables_Misc;
2638: