DBA Data[Home] [Help]

APPS.JL_BR_AR_LOG_VALIDATION dependencies on CE_BANK_ACCOUNTS

Line 165: FROM ce_bank_accounts acct,

161: */
162:
163: SELECT distinct acct.secondary_account_reference
164: INTO X_dual_num
165: FROM ce_bank_accounts acct,
166: ce_bank_acct_uses_all acctUse,
167: jl_br_ar_collection_docs cd,
168: ar_payment_schedules_all arps
169: WHERE cd.document_id = X_company_use

Line 214: ce_bank_accounts CeBankAccount,

210: INTO X_payment_schedule_id,
211: X_document_status,
212: X_remittance_bank_id
213: FROM jl_br_ar_collection_docs doc,
214: ce_bank_accounts CeBankAccount,
215: ce_bank_acct_uses_all CeBankAcctUse,
216: hz_parties HzPartyBank
217: Where doc.bank_acct_use_id = CeBankAcctUse.bank_acct_use_id
218: And CeBankAcctUse.bank_account_id = CeBankAccount.bank_account_id