2244: Select
2245: DECODE(l_rev_exists, 'Y', reversal_date, receipt_date),
2246: DECODE(l_rev_exists, 'Y', l_doc_created_by_d, created_by),
2247: DECODE(l_rev_exists, 'Y', l_doc_creation_date_d, creation_date)
2248: From AR_Cash_Receipts_All
2249: Where to_char(Cash_Receipt_Id) = p_refer2;
2250:
2251: --Bug 2532729 Start
2252:
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;
2593: FETCH Receivables_Exists INTO l_rev_exists;
2594: CLOSE Receivables_Exists;
2595: