DBA Data[Home] [Help]

APPS.JL_AR_RECEIVABLE_APPLICATIONS dependencies on JL_BR_AR_REC_MET_ACCTS_EXT

Line 124: jl_br_ar_rec_met_accts_ext arrma

120: FROM ar_receipt_methods arrm,
121: ar_system_parameters arsp,
122: ar_payment_schedules arps,
123: jl_br_ar_collection_docs dc,
124: jl_br_ar_rec_met_accts_ext arrma
125: WHERE dc.payment_schedule_id = x_payment_schedule_id
126: AND arps.payment_schedule_id = dc.payment_schedule_id
127: AND arrma.bank_account_id = dc.bank_account_id
128: AND arrma.receipt_method_id = dc.receipt_method_id

Line 307: FROM jl_br_ar_rec_met_accts_ext

303: x_int_revenue_rectrx_id,
304: x_int_revenue_ccid,
305: x_calc_interest_ccid,
306: x_calc_interest_rectrx_id
307: FROM jl_br_ar_rec_met_accts_ext
308: WHERE receipt_method_id = x_rcpt_method_id
309: AND bank_acct_use_id = x_bank_acct_id;
310: EXCEPTION
311: WHEN NO_DATA_FOUND THEN x_return := -1;