DBA Data[Home] [Help]

APPS.JL_BR_AR_LOG_VALIDATION dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 154: ar_payment_schedules_all arps

150: SELECT distinct aba.global_attribute7
151: INTO X_dual_num
152: FROM ap_bank_accounts_all aba,
153: jl_br_ar_collection_docs cd,
154: ar_payment_schedules_all arps
155: WHERE cd.document_id = X_company_use
156: AND aba.bank_account_id = cd.bank_account_id
157: AND arps.payment_schedule_id = cd.payment_schedule_id
158: -- bug 1892303

Line 168: ar_payment_schedules_all arps

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
170: AND acctUse.bank_acct_use_id = cd.bank_acct_use_id
171: AND acct.bank_account_id = acctUse.bank_account_id
172: AND arps.payment_schedule_id = cd.payment_schedule_id