DBA Data[Home] [Help]

APPS.JL_BR_AR_LOG_VALIDATION dependencies on CE_BANK_ACCOUNTS

Line 263: FROM ce_bank_accounts acct,

259: */
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

Line 316: ce_bank_accounts CeBankAccount,

312: INTO X_payment_schedule_id,
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