APPS.FV_FACTS_TRX_REGISTER dependencies on AR_MISC_CASH_DISTRIBUTIONS_ALL

Line 2104: FROM ar_misc_cash_distributions_all ara,

2100: --hca.party_id
2101: hca.cust_account_id
2102: INTO l_reference_4,
2103: l_reference_7
2104: FROM ar_misc_cash_distributions_all ara,
2105: ar_cash_receipts_all acr,
2106: hz_cust_site_uses_all hcsu,
2107: hz_cust_acct_sites_all hcas,
2108: hz_cust_accounts hca

Line 2233: FROM ar_misc_cash_distributions_all ara,

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

Line 3258: -- FROM ar_misc_cash_distributions_all

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
3259: -- WHERE misc_cash_distribution_id = l_cash_receipt_hist_id
3260: -- AND created_from = 'ARP_REVERSE_RECEIPT.REVERSE';
3261: --CURSOR Receivables_Distrib IS
3262: -- SELECT 'Y'

Line 3263: -- FROM ar_misc_cash_distributions_all

3259: -- WHERE misc_cash_distribution_id = l_cash_receipt_hist_id
3260: -- AND created_from = 'ARP_REVERSE_RECEIPT.REVERSE';
3261: --CURSOR Receivables_Distrib IS
3262: -- SELECT 'Y'
3263: -- FROM ar_misc_cash_distributions_all
3264: -- WHERE misc_cash_distribution_id = to_number(l_cash_receipt_hist_id);
3265: CURSOR Pay_Treas_Check IS
3266: SELECT void_date, checkrun_name
3267: FROM ap_checks_all

Line 3958: FROM ar_misc_cash_distributions_all

3954: -- Find out IF Reference_2 contains Misc_Cash_Distribution_Id
3955: IF (p_rec_public_law_code_col IS NOT NULL) THEN
3956: l_rec_public_law_code := NULL;
3957: l_select := 'SELECT ''Y'', '||p_rec_public_law_code_col||'
3958: FROM ar_misc_cash_distributions_all
3959: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
3960: OPEN Receivables_Distrib FOR l_select;
3961: FETCH Receivables_Distrib into l_rev_exists, l_rec_public_law_code;
3962: CLOSE Receivables_Distrib;

Line 3967: FROM ar_misc_cash_distributions_all

3963: p_rec_public_law_code := l_rec_public_law_code;
3964: ELSE
3965: p_rec_public_law_code := NULL;
3966: l_select := 'SELECT ''Y''
3967: FROM ar_misc_cash_distributions_all
3968: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
3969: OPEN Receivables_Distrib FOR l_select;
3970: FETCH Receivables_Distrib into l_rev_exists;
3971: CLOSE Receivables_Distrib;

Line 3978: ||'Ar_Misc_Cash_Distributions_All: '

3974: IF (l_rev_exists = 'Y')
3975: THEN
3976: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3977: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN '
3978: ||'Ar_Misc_Cash_Distributions_All: '
3979: ||l_cash_receipt_hist_id);
3980: END IF;
3981: l_rev_exists := 'N';
3982: -- Select the document info

Line 3983: -- from Ar_Misc_Cash_Distributions_All table

3979: ||l_cash_receipt_hist_id);
3980: END IF;
3981: l_rev_exists := 'N';
3982: -- Select the document info
3983: -- from Ar_Misc_Cash_Distributions_All table
3984: IF (p_rec_public_law_code_col IS NOT NULL) THEN
3985: l_rec_public_law_code := NULL;
3986: l_select := ' SELECT ''Y'', creation_date, created_by, '||p_rec_public_law_code_col||'
3987: FROM ar_misc_cash_distributions_all

Line 3987: FROM ar_misc_cash_distributions_all

3983: -- from Ar_Misc_Cash_Distributions_All table
3984: IF (p_rec_public_law_code_col IS NOT NULL) THEN
3985: l_rec_public_law_code := NULL;
3986: l_select := ' SELECT ''Y'', creation_date, created_by, '||p_rec_public_law_code_col||'
3987: FROM ar_misc_cash_distributions_all
3988: WHERE misc_cash_distribution_id = '||l_cash_receipt_hist_id||'
3989: AND created_from = ''ARP_REVERSE_RECEIPT.REVERSE''';
3990: OPEN Receivables_Misc FOR l_select;
3991: FETCH Receivables_Misc into l_rev_exists,

Line 4002: FROM ar_misc_cash_distributions_all

3998: END IF;
3999: ELSE
4000: p_rec_public_law_code := NULL;
4001: l_select := ' SELECT ''Y'', creation_date, created_by
4002: FROM ar_misc_cash_distributions_all
4003: WHERE misc_cash_distribution_id = '||l_cash_receipt_hist_id||'
4004: AND created_from = ''ARP_REVERSE_RECEIPT.REVERSE''';
4005: OPEN Receivables_Misc FOR l_select;
4006: FETCH Receivables_Misc into l_rev_exists,

Line 4036: FROM ar_misc_cash_distributions_all

4032: IF (p_je_category_name = 'Misc Receipts') THEN
4033: IF ((p_rec_public_law_code_col IS NOT NULL) AND (p_rec_public_law_code IS NULL)) THEN
4034: l_rec_public_law_code := NULL;
4035: l_select := 'SELECT '||p_rec_public_law_code_col||'
4036: FROM ar_misc_cash_distributions_all
4037: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
4038: OPEN Receivables_Distrib FOR l_select;
4039: FETCH Receivables_Distrib into l_rec_public_law_code;
4040: