APPS.FV_FACTS_TRX_REGISTER dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 2046: FROM ar_cash_receipt_history_all ara,

2042: --hca.party_id
2043: hca.cust_account_id
2044: INTO l_reference_4,
2045: l_reference_7
2046: FROM ar_cash_receipt_history_all ara,
2047: ar_cash_receipts_all acr,
2048: hz_cust_site_uses_all hcsu,
2049: hz_cust_acct_sites_all hcas,
2050: hz_cust_accounts hca

Line 2234: ar_cash_receipt_history_all acrh,

2230: INTO l_reference_2,
2231: l_reference_5,
2232: l_reference_4
2233: FROM ar_misc_cash_distributions_all ara,
2234: ar_cash_receipt_history_all acrh,
2235: ar_cash_receipts_all acr
2236: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2237: AND ara.cash_receipt_id = acr.cash_receipt_id
2238: AND ara.cash_receipt_id = acrh.cash_receipt_id

Line 3178: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;

3174: l_gl_date Date;
3175: l_rec_public_law_code VARCHAR2(150);
3176: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
3177: l_event_type_code ap_accounting_events.event_type_code%TYPE;
3178: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
3179: l_dummy_rev_exists VARCHAR2(1);
3180:
3181:
3182: TYPE common_ref_type IS REF CURSOR ;

Line 3232: FROM ar_cash_receipt_history_all

3228: FROM ar_cash_receipts_all
3229: WHERE cash_receipt_id = to_number(l_refer2);
3230: CURSOR Receivables_Exists IS
3231: SELECT 'Y'
3232: FROM ar_cash_receipt_history_all
3233: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id);
3234: CURSOR Receivables_Applications IS
3235: SELECT cash_receipt_history_id
3236: FROM ar_receivable_applications_all

Line 3245: FROM ar_cash_receipt_history_all

3241: c_cash_receipt_id VARCHAR2
3242: )
3243: IS
3244: SELECT 'Y', status
3245: FROM ar_cash_receipt_history_all
3246: WHERE cash_receipt_history_id = c_cash_receipt_hist_id
3247: AND cash_receipt_id = c_cash_receipt_id;
3248: CURSOR Receivables_History
3249: (

Line 3254: FROM ar_cash_receipt_history_all

3250: c_cash_receipt_hist_id NUMBER
3251: )
3252: IS
3253: SELECT 'Y', creation_date, created_by
3254: FROM ar_cash_receipt_history_all
3255: WHERE reversal_cash_receipt_hist_id = c_cash_receipt_hist_id;
3256: --CURSOR Receivables_Misc IS
3257: -- SELECT 'Y', creation_date, created_by
3258: -- FROM ar_misc_cash_distributions_all

Line 3893: ' Ar_Cash_Receipt_History_All ... REVERSAL');

3889: IF (l_rev_exists = 'Y')
3890: THEN
3891: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3892: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN'||
3893: ' Ar_Cash_Receipt_History_All ... REVERSAL');
3894: END IF;
3895: END IF;
3896: END IF;
3897: IF (p_je_category_name <> 'Misc Receipts') AND (l_rev_exists = 'C')

Line 3921: ||' Ar_Cash_Receipt_History_All: '

3917: IF (l_rev_exists = 'Y')
3918: THEN
3919: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN'
3921: ||' Ar_Cash_Receipt_History_All: '
3922: ||l_cash_receipt_hist_id);
3923: END IF;
3924: l_rev_exists := 'N';
3925:

Line 3935: -- AR_CASH_RECEIPT_HISTORY_All table

3931: p_reversed := 'R';
3932: END IF;
3933:
3934: -- Select the document info from
3935: -- AR_CASH_RECEIPT_HISTORY_All table
3936: OPEN Receivables_History (TO_NUMBER(l_cash_receipt_hist_id));
3937: FETCH Receivables_History into l_rev_exists,
3938: l_doc_creation_date_d,
3939: l_doc_created_by_d;