DBA Data[Home] [Help]

APPS.JL_BR_AR_LOG_VALIDATION dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 252: ar_payment_schedules_all arps

248: SELECT distinct aba.global_attribute7
249: INTO X_dual_num
250: FROM ap_bank_accounts_all aba,
251: jl_br_ar_collection_docs cd,
252: ar_payment_schedules_all arps
253: WHERE cd.document_id = X_company_use
254: AND aba.bank_account_id = cd.bank_account_id
255: AND arps.payment_schedule_id = cd.payment_schedule_id
256: -- bug 1892303

Line 266: ar_payment_schedules_all arps

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
269: AND acct.bank_account_id = acctUse.bank_account_id
270: AND arps.payment_schedule_id = cd.payment_schedule_id