APPS.FV_FACTS_TRX_REGISTER dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 1966: FROM ar_cash_receipt_history_all ara,

1962: --hca.party_id
1963: hca.cust_account_id
1964: INTO l_reference_4,
1965: l_reference_7
1966: FROM ar_cash_receipt_history_all ara,
1967: ar_cash_receipts_all acr,
1968: hz_cust_site_uses_all hcsu,
1969: hz_cust_acct_sites_all hcas,
1970: hz_cust_accounts hca

Line 2150: ar_cash_receipt_history_all acrh,

2146: INTO l_reference_2,
2147: l_reference_5,
2148: l_reference_4
2149: FROM ar_misc_cash_distributions_all ara,
2150: ar_cash_receipt_history_all acrh,
2151: ar_cash_receipts_all acr
2152: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2153: AND ara.cash_receipt_id = acr.cash_receipt_id
2154: AND ara.cash_receipt_id = acrh.cash_receipt_id;

Line 2964: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;

2960: l_gl_date Date;
2961: l_rec_public_law_code VARCHAR2(150);
2962: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
2963: l_event_type_code ap_accounting_events.event_type_code%TYPE;
2964: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
2965: l_dummy_rev_exists VARCHAR2(1);
2966:
2967:
2968: TYPE common_ref_type IS REF CURSOR ;

Line 3018: FROM ar_cash_receipt_history_all

3014: FROM ar_cash_receipts_all
3015: WHERE cash_receipt_id = to_number(l_refer2);
3016: CURSOR Receivables_Exists IS
3017: SELECT 'Y'
3018: FROM ar_cash_receipt_history_all
3019: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id);
3020: CURSOR Receivables_Applications IS
3021: SELECT cash_receipt_history_id
3022: FROM ar_receivable_applications_all

Line 3031: FROM ar_cash_receipt_history_all

3027: c_cash_receipt_id VARCHAR2
3028: )
3029: IS
3030: SELECT 'Y', status
3031: FROM ar_cash_receipt_history_all
3032: WHERE cash_receipt_history_id = c_cash_receipt_hist_id
3033: AND cash_receipt_id = c_cash_receipt_id;
3034: CURSOR Receivables_History
3035: (

Line 3040: FROM ar_cash_receipt_history_all

3036: c_cash_receipt_hist_id NUMBER
3037: )
3038: IS
3039: SELECT 'Y', creation_date, created_by
3040: FROM ar_cash_receipt_history_all
3041: WHERE reversal_cash_receipt_hist_id = c_cash_receipt_hist_id;
3042: --CURSOR Receivables_Misc IS
3043: -- SELECT 'Y', creation_date, created_by
3044: -- FROM ar_misc_cash_distributions_all

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

3672: IF (l_rev_exists = 'Y')
3673: THEN
3674: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN'||
3676: ' Ar_Cash_Receipt_History_All ... REVERSAL');
3677: END IF;
3678: END IF;
3679: END IF;
3680: IF (p_je_category_name <> 'Misc Receipts') AND (l_rev_exists = 'C')

Line 3704: ||' Ar_Cash_Receipt_History_All: '

3700: IF (l_rev_exists = 'Y')
3701: THEN
3702: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3703: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN'
3704: ||' Ar_Cash_Receipt_History_All: '
3705: ||l_cash_receipt_hist_id);
3706: END IF;
3707: l_rev_exists := 'N';
3708:

Line 3718: -- AR_CASH_RECEIPT_HISTORY_All table

3714: p_reversed := 'R';
3715: END IF;
3716:
3717: -- Select the document info from
3718: -- AR_CASH_RECEIPT_HISTORY_All table
3719: OPEN Receivables_History (TO_NUMBER(l_cash_receipt_hist_id));
3720: FETCH Receivables_History into l_rev_exists,
3721: l_doc_creation_date_d,
3722: l_doc_created_by_d;