APPS.FV_GTAS_TRX_REGISTER dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 2631: FROM ar_cash_receipt_history_all ara,

2627: --hca.party_id
2628: to_char(hca.cust_account_id)
2629: INTO l_reference_4,
2630: l_reference_7
2631: FROM ar_cash_receipt_history_all ara,
2632: ar_cash_receipts_all acr,
2633: hz_cust_site_uses_all hcsu,
2634: hz_cust_acct_sites_all hcas,
2635: hz_cust_accounts hca

Line 2812: ar_cash_receipt_history_all acrh,

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
2816: AND ara.cash_receipt_id = acrh.cash_receipt_id

Line 3346: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;

3342: l_gl_date Date;
3343: l_rec_public_law_code VARCHAR2(150);
3344: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
3345: l_event_type_code ap_accounting_events.event_type_code%TYPE;
3346: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
3347: l_dummy_rev_exists VARCHAR2(1);
3348:
3349:
3350: TYPE common_ref_type IS REF CURSOR ;

Line 3392: FROM ar_cash_receipt_history_all

3388: WHERE cash_receipt_id = to_number(l_refer2);
3389:
3390: CURSOR Receivables_Exists IS
3391: SELECT 'Y'
3392: FROM ar_cash_receipt_history_all
3393: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id);
3394: CURSOR Receivables_Applications IS
3395: SELECT cash_receipt_history_id
3396: FROM ar_receivable_applications_all

Line 3406: FROM ar_cash_receipt_history_all

3402: c_cash_receipt_id VARCHAR2
3403: )
3404: IS
3405: SELECT 'Y', status
3406: FROM ar_cash_receipt_history_all
3407: WHERE cash_receipt_history_id = c_cash_receipt_hist_id
3408: AND cash_receipt_id = c_cash_receipt_id;
3409:
3410: CURSOR Receivables_History

Line 3416: FROM ar_cash_receipt_history_all

3412: c_cash_receipt_hist_id NUMBER
3413: )
3414: IS
3415: SELECT 'Y', creation_date, created_by
3416: FROM ar_cash_receipt_history_all
3417: WHERE reversal_cash_receipt_hist_id = c_cash_receipt_hist_id;
3418:
3419: CURSOR Pay_Treas_Check IS
3420: SELECT void_date, checkrun_name

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

3988: CLOSE Receivables_History;
3989:
3990: IF (l_rev_exists = 'Y')THEN
3991: log(l_module,'Cash Receipt Hist ID exists in'||
3992: ' Ar_Cash_Receipt_History_All ... REVERSAL');
3993:
3994: END IF;
3995: END IF;
3996: IF (p_je_category_name <> 'Misc Receipts') AND (l_rev_exists = 'C')

Line 4017: ||' Ar_Cash_Receipt_History_All: '

4013: FETCH Receivables_Exists INTO l_rev_exists;
4014: CLOSE Receivables_Exists;
4015: IF (l_rev_exists = 'Y') THEN
4016: log(l_module,'CASH RECEIPT HIST ID EXITS IN'
4017: ||' Ar_Cash_Receipt_History_All: '
4018: ||l_cash_receipt_hist_id);
4019:
4020: l_rev_exists := 'N';
4021:

Line 4031: -- AR_CASH_RECEIPT_HISTORY_All table

4027: p_reversed := 'R';
4028: END IF;
4029:
4030: -- Select the document info from
4031: -- AR_CASH_RECEIPT_HISTORY_All table
4032: OPEN Receivables_History (TO_NUMBER(l_cash_receipt_hist_id));
4033: FETCH Receivables_History
4034: into l_rev_exists,
4035: l_doc_creation_date_d,