DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 581: ar_payment_schedules_all ps,

577: l_name,
578: l_bordero_id,
579: l_payment_schedule_id
580: from ra_customer_trx_all ct,
581: ar_payment_schedules_all ps,
582: jl_br_ar_select_controls sc,
583: jl_br_ar_borderos bo,
584: jl_br_ar_collection_docs cd
585: where ct.customer_trx_id = cd.customer_trx_id

Line 1229: ar_payment_schedules_all ps

1225: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id
1226: and nvl(o2.flag_post_gl,'N') = 'N'))))
1227: ))) X,
1228: gl_row_multipliers grm,
1229: ar_payment_schedules_all ps
1230: where grm.multiplier < 7
1231: and ps.payment_schedule_id = x.payment_schedule_id
1232: and not exists (
1233: select /*+ use_nl_with_index(rerun, JL_BR_AR_DISTRIBUTNS_U2) */ null