APPS.FV_FACTS_TRX_REGISTER dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 2017: FROM ar_receivable_applications_all ara,

2013: --hca.party_id
2014: hca.cust_account_id
2015: INTO l_reference_4,
2016: l_reference_7
2017: FROM ar_receivable_applications_all ara,
2018: ar_cash_receipts_all acr,
2019: hz_cust_site_uses_all hcsu,
2020: hz_cust_acct_sites_all hcas,
2021: hz_cust_accounts hca

Line 3236: FROM ar_receivable_applications_all

3232: FROM ar_cash_receipt_history_all
3233: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id);
3234: CURSOR Receivables_Applications IS
3235: SELECT cash_receipt_history_id
3236: FROM ar_receivable_applications_all
3237: WHERE receivable_application_id = TO_NUMBER(l_cash_receipt_hist_id);
3238: CURSOR Receivables_Hist
3239: (
3240: c_cash_receipt_hist_id NUMBER,

Line 3351: FROM ar_receivable_applications_all

3347: FROM ar_adjustments_all
3348: WHERE adjustment_id = l_refer2;
3349: CURSOR Receivables_CMA IS
3350: SELECT apply_date, creation_date, created_by
3351: FROM ar_receivable_applications_all
3352: WHERE receivable_application_id = l_refer2;
3353: CURSOR Receivables_Memos_Inv IS
3354: SELECT trx_date, creation_date, created_by
3355: FROM ra_customer_trx_all

Line 3909: ||' Ar_Receivable_Applications_All: '

3905: THEN
3906: l_cash_receipt_hist_id := l_temp_cr_hist_id;
3907: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3908: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN'
3909: ||' Ar_Receivable_Applications_All: '
3910: ||l_cash_receipt_hist_id);
3911: END IF;
3912: -- Use cash_receipt_history_id obtained above to find
3913: -- IF a row exits in Ar_Cash_Receipts_All