APPS.FV_GTAS_TRX_REGISTER dependencies on AR_MISC_CASH_DISTRIBUTIONS_ALL

Line 2688: FROM ar_misc_cash_distributions_all ara,

2684: --hca.party_id
2685: to_char(hca.cust_account_id)
2686: INTO l_reference_4,
2687: l_reference_7
2688: FROM ar_misc_cash_distributions_all ara,
2689: ar_cash_receipts_all acr,
2690: hz_cust_site_uses_all hcsu,
2691: hz_cust_acct_sites_all hcas,
2692: hz_cust_accounts hca

Line 2811: FROM ar_misc_cash_distributions_all ara,

2807: acr.receipt_number
2808: INTO l_reference_2,
2809: l_reference_5,
2810: l_reference_4
2811: FROM ar_misc_cash_distributions_all ara,
2812: ar_cash_receipt_history_all acrh,
2813: ar_cash_receipts_all acr
2814: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2815: AND ara.cash_receipt_id = acr.cash_receipt_id

Line 4051: FROM ar_misc_cash_distributions_all

4047: -- Find out IF Reference_2 contains Misc_Cash_Distribution_Id
4048: IF (p_rec_public_law_code_col IS NOT NULL) THEN
4049: l_rec_public_law_code := NULL;
4050: l_select := 'SELECT ''Y'', '||p_rec_public_law_code_col||'
4051: FROM ar_misc_cash_distributions_all
4052: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
4053: OPEN Receivables_Distrib FOR l_select;
4054: FETCH Receivables_Distrib into l_rev_exists, l_rec_public_law_code;
4055: CLOSE Receivables_Distrib;

Line 4060: FROM ar_misc_cash_distributions_all

4056: p_rec_public_law_code := l_rec_public_law_code;
4057: ELSE
4058: p_rec_public_law_code := NULL;
4059: l_select := 'SELECT ''Y''
4060: FROM ar_misc_cash_distributions_all
4061: WHERE misc_cash_distribution_id = '||to_number(l_cash_receipt_hist_id);
4062: OPEN Receivables_Distrib FOR l_select;
4063: FETCH Receivables_Distrib into l_rev_exists;
4064: CLOSE Receivables_Distrib;

Line 4070: ||'Ar_Misc_Cash_Distributions_All: '

4066:
4067: IF (l_rev_exists = 'Y')THEN
4068:
4069: log(l_module,' CASH RECEIPT HIST ID EXITS IN '
4070: ||'Ar_Misc_Cash_Distributions_All: '
4071: ||l_cash_receipt_hist_id);
4072:
4073: l_rev_exists := 'N';
4074: -- Select the document info

Line 4075: -- from Ar_Misc_Cash_Distributions_All table

4071: ||l_cash_receipt_hist_id);
4072:
4073: l_rev_exists := 'N';
4074: -- Select the document info
4075: -- from Ar_Misc_Cash_Distributions_All table
4076: IF (p_rec_public_law_code_col IS NOT NULL) THEN
4077: l_rec_public_law_code := NULL;
4078: l_select := ' SELECT ''Y'', creation_date, created_by, '||
4079: p_rec_public_law_code_col||'

Line 4080: FROM ar_misc_cash_distributions_all

4076: IF (p_rec_public_law_code_col IS NOT NULL) THEN
4077: l_rec_public_law_code := NULL;
4078: l_select := ' SELECT ''Y'', creation_date, created_by, '||
4079: p_rec_public_law_code_col||'
4080: FROM ar_misc_cash_distributions_all
4081: WHERE misc_cash_distribution_id = '||
4082: l_cash_receipt_hist_id||'
4083: AND created_from = ''ARP_REVERSE_RECEIPT.REVERSE''';
4084: OPEN Receivables_Misc FOR l_select;

Line 4096: FROM ar_misc_cash_distributions_all

4092: END IF;
4093: ELSE
4094: p_rec_public_law_code := NULL;
4095: l_select := ' SELECT ''Y'', creation_date, created_by
4096: FROM ar_misc_cash_distributions_all
4097: WHERE misc_cash_distribution_id = '||
4098: l_cash_receipt_hist_id||'
4099: AND created_from = ''ARP_REVERSE_RECEIPT.REVERSE''';
4100: OPEN Receivables_Misc FOR l_select;

Line 4133: FROM ar_misc_cash_distributions_all

4129: IF ((p_rec_public_law_code_col IS NOT NULL) AND
4130: (p_rec_public_law_code IS NULL)) THEN
4131: l_rec_public_law_code := NULL;
4132: l_select := 'SELECT '||p_rec_public_law_code_col||'
4133: FROM ar_misc_cash_distributions_all
4134: WHERE misc_cash_distribution_id = '||
4135: to_number(l_cash_receipt_hist_id);
4136: OPEN Receivables_Distrib FOR l_select;
4137: FETCH Receivables_Distrib into l_rec_public_law_code;