DBA Data[Home] [Help]

APPS.PSA_MFAR_VAL_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 352: from ar_receivable_applications_all

348:
349: elsif X_SOURCE_TYPE = 'RCT' then
350: select applied_customer_trx_id
351: into l_app_cust_trx_id
352: from ar_receivable_applications_all
353: where receivable_application_id = X_SOURCE_ID;
354:
355: return AR_MFAR_VALIDATE_CHECK( l_app_cust_trx_id,'TRX', X_SET_OF_BOOKS_ID );
356:

Line 404: -- ar_cash_receipts_ALL c,ar_receivable_applications_ALL d

400: fnd_profile.get('ORG_ID',l_org_id);
401:
402: SELECT 'X' into l_rct_check
403: from psa_trx_types_ALL a, ra_customer_trx_ALL b
404: -- ar_cash_receipts_ALL c,ar_receivable_applications_ALL d
405: -- where b.customer_trx_id = d.applied_customer_trx_id
406: -- and c.cash_receipt_id = d.cash_receipt_id
407: -- and
408: where a.psa_trx_type_id = b.cust_trx_type_id