DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 2601: FROM ar_receivable_applications_all ara,

2597: --hca.party_id
2598: to_char(hca.cust_account_id)
2599: INTO l_reference_4,
2600: l_reference_7
2601: FROM ar_receivable_applications_all ara,
2602: ar_cash_receipts_all acr,
2603: hz_cust_site_uses_all hcsu,
2604: hz_cust_acct_sites_all hcas,
2605: hz_cust_accounts hca

Line 3396: FROM ar_receivable_applications_all

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
3397: WHERE receivable_application_id = TO_NUMBER(l_cash_receipt_hist_id);
3398:
3399: CURSOR Receivables_Hist
3400: (

Line 3490: FROM ar_receivable_applications_all

3486: FROM ar_adjustments_all
3487: WHERE adjustment_id = l_refer2;
3488: CURSOR Receivables_CMA IS
3489: SELECT apply_date, creation_date, created_by
3490: FROM ar_receivable_applications_all
3491: WHERE receivable_application_id = l_refer2;
3492: CURSOR Receivables_Memos_Inv IS
3493: SELECT trx_date, creation_date, created_by
3494: FROM ra_customer_trx_all

Line 4007: ||' Ar_Receivable_Applications_All: '

4003: IF (l_temp_cr_hist_id IS NOT NULL) THEN
4004: l_cash_receipt_hist_id := l_temp_cr_hist_id;
4005:
4006: log(l_module,'CASH RECEIPT HIST ID EXITS IN'
4007: ||' Ar_Receivable_Applications_All: '
4008: ||l_cash_receipt_hist_id);
4009:
4010: -- Use cash_receipt_history_id obtained above to find
4011: -- IF a row exits in Ar_Cash_Receipts_All