DBA Data[Home] [Help]

APPS.JL_BR_AR_LOG_VALIDATION dependencies on CE_BANK_ACCT_USES_ALL

Line 264: ce_bank_acct_uses_all acctUse,

260:
261: SELECT distinct acct.secondary_account_reference
262: INTO X_dual_num
263: FROM ce_bank_accounts acct,
264: ce_bank_acct_uses_all acctUse,
265: jl_br_ar_collection_docs cd,
266: ar_payment_schedules_all arps
267: WHERE cd.document_id = X_company_use
268: AND acctUse.bank_acct_use_id = cd.bank_acct_use_id

Line 317: ce_bank_acct_uses_all CeBankAcctUse,

313: X_document_status,
314: X_remittance_bank_id
315: FROM jl_br_ar_collection_docs doc,
316: ce_bank_accounts CeBankAccount,
317: ce_bank_acct_uses_all CeBankAcctUse,
318: hz_parties HzPartyBank
319: Where doc.bank_acct_use_id = CeBankAcctUse.bank_acct_use_id
320: And CeBankAcctUse.bank_account_id = CeBankAccount.bank_account_id
321: And CeBankAccount.BANK_ID = HzPartyBank.PARTY_ID