APPS.FV_FACTS_TRX_REGISTER dependencies on AR_MISC_CASH_DISTRIBUTIONS_ALL

Line 2024: FROM ar_misc_cash_distributions_all ara,

2020: --hca.party_id
2021: hca.cust_account_id
2022: INTO l_reference_4,
2023: l_reference_7
2024: FROM ar_misc_cash_distributions_all ara,
2025: ar_cash_receipts_all acr,
2026: hz_cust_site_uses_all hcsu,
2027: hz_cust_acct_sites_all hcas,
2028: hz_cust_accounts hca

Line 2149: FROM ar_misc_cash_distributions_all ara,

2145: acr.receipt_number
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

Line 3044: -- FROM ar_misc_cash_distributions_all

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
3045: -- WHERE misc_cash_distribution_id = l_cash_receipt_hist_id
3046: -- AND created_from = 'ARP_REVERSE_RECEIPT.REVERSE';
3047: --CURSOR Receivables_Distrib IS
3048: -- SELECT 'Y'

Line 3049: -- FROM ar_misc_cash_distributions_all

3045: -- WHERE misc_cash_distribution_id = l_cash_receipt_hist_id
3046: -- AND created_from = 'ARP_REVERSE_RECEIPT.REVERSE';
3047: --CURSOR Receivables_Distrib IS
3048: -- SELECT 'Y'
3049: -- FROM ar_misc_cash_distributions_all
3050: -- WHERE misc_cash_distribution_id = to_number(l_cash_receipt_hist_id);
3051: CURSOR Pay_Treas_Check IS
3052: SELECT void_date, checkrun_name
3053: FROM ap_checks_all

Line 3741: FROM ar_misc_cash_distributions_all

3737: -- Find out IF Reference_2 contains Misc_Cash_Distribution_Id
3738: IF (p_rec_public_law_code_col IS NOT NULL) THEN
3739: l_rec_public_law_code := NULL;
3740: l_select := 'SELECT ''Y'', '||p_rec_public_law_code_col||'
3741: FROM ar_misc_cash_distributions_all
3742: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
3743: OPEN Receivables_Distrib FOR l_select;
3744: FETCH Receivables_Distrib into l_rev_exists, l_rec_public_law_code;
3745: CLOSE Receivables_Distrib;

Line 3750: FROM ar_misc_cash_distributions_all

3746: p_rec_public_law_code := l_rec_public_law_code;
3747: ELSE
3748: p_rec_public_law_code := NULL;
3749: l_select := 'SELECT ''Y''
3750: FROM ar_misc_cash_distributions_all
3751: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
3752: OPEN Receivables_Distrib FOR l_select;
3753: FETCH Receivables_Distrib into l_rev_exists;
3754: CLOSE Receivables_Distrib;

Line 3761: ||'Ar_Misc_Cash_Distributions_All: '

3757: IF (l_rev_exists = 'Y')
3758: THEN
3759: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN '
3761: ||'Ar_Misc_Cash_Distributions_All: '
3762: ||l_cash_receipt_hist_id);
3763: END IF;
3764: l_rev_exists := 'N';
3765: -- Select the document info

Line 3766: -- from Ar_Misc_Cash_Distributions_All table

3762: ||l_cash_receipt_hist_id);
3763: END IF;
3764: l_rev_exists := 'N';
3765: -- Select the document info
3766: -- from Ar_Misc_Cash_Distributions_All table
3767: IF (p_rec_public_law_code_col IS NOT NULL) THEN
3768: l_rec_public_law_code := NULL;
3769: l_select := ' SELECT ''Y'', creation_date, created_by, '||p_rec_public_law_code_col||'
3770: FROM ar_misc_cash_distributions_all

Line 3770: FROM ar_misc_cash_distributions_all

3766: -- from Ar_Misc_Cash_Distributions_All table
3767: IF (p_rec_public_law_code_col IS NOT NULL) THEN
3768: l_rec_public_law_code := NULL;
3769: l_select := ' SELECT ''Y'', creation_date, created_by, '||p_rec_public_law_code_col||'
3770: FROM ar_misc_cash_distributions_all
3771: WHERE misc_cash_distribution_id = '||l_cash_receipt_hist_id||'
3772: AND created_from = ''ARP_REVERSE_RECEIPT.REVERSE''';
3773: OPEN Receivables_Misc FOR l_select;
3774: FETCH Receivables_Misc into l_rev_exists,

Line 3785: FROM ar_misc_cash_distributions_all

3781: END IF;
3782: ELSE
3783: p_rec_public_law_code := NULL;
3784: l_select := ' SELECT ''Y'', creation_date, created_by
3785: FROM ar_misc_cash_distributions_all
3786: WHERE misc_cash_distribution_id = '||l_cash_receipt_hist_id||'
3787: AND created_from = ''ARP_REVERSE_RECEIPT.REVERSE''';
3788: OPEN Receivables_Misc FOR l_select;
3789: FETCH Receivables_Misc into l_rev_exists,

Line 3819: FROM ar_misc_cash_distributions_all

3815: IF (p_je_category_name = 'Misc Receipts') THEN
3816: IF ((p_rec_public_law_code_col IS NOT NULL) AND (p_rec_public_law_code IS NULL)) THEN
3817: l_rec_public_law_code := NULL;
3818: l_select := 'SELECT '||p_rec_public_law_code_col||'
3819: FROM ar_misc_cash_distributions_all
3820: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
3821: OPEN Receivables_Distrib FOR l_select;
3822: FETCH Receivables_Distrib into l_rec_public_law_code;
3823: