DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 561: ar_payment_schedules_all ps,

557: l_name,
558: l_bordero_id,
559: l_payment_schedule_id
560: from ra_customer_trx_all ct,
561: ar_payment_schedules_all ps,
562: jl_br_ar_select_controls sc,
563: jl_br_ar_borderos bo,
564: jl_br_ar_collection_docs cd
565: where ct.customer_trx_id = cd.customer_trx_id

Line 1192: ar_payment_schedules_all ps

1188: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id
1189: and nvl(o2.flag_post_gl,'N') = 'N'))))
1190: ))) X,
1191: gl_row_multipliers grm,
1192: ar_payment_schedules_all ps
1193: where grm.multiplier < 7
1194: and ps.payment_schedule_id = x.payment_schedule_id
1195: and not exists (
1196: select /*+ use_nl_with_index(rerun, JL_BR_AR_DISTRIBUTNS_U2) */ null