DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_BR_AR_BORDEROS

Line 583: jl_br_ar_borderos bo,

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
586: and ct.org_id = cd.org_id
587: and ps.payment_schedule_id = cd.payment_schedule_id

Line 1188: jl_br_ar_borderos_all b

1184: jl_br_ar_occurrence_docs_all oc,
1185: ra_customer_trx_all ract,
1186: jl_br_ar_bank_occurrences bo,
1187: jl_br_ar_select_accounts_all csc,
1188: jl_br_ar_borderos_all b
1189: where oc.document_id between l_start_id and l_end_id
1190: and nvl(oc.occurrence_status,'CONFIRMED') <> 'CREATED'
1191: and oc.document_id = cd.document_id
1192: and cd.customer_trx_id = ract.customer_trx_id

Line 1843: jl_br_ar_borderos_all b,

1839: jl_br_ar_collection_docs_all cd,
1840: ra_customer_trx_all ract,
1841: jl_br_ar_bank_occurrences bo,
1842: jl_br_ar_select_accounts_all csc,
1843: jl_br_ar_borderos_all b,
1844: ar_system_parameters_all sys,
1845: gl_date_period_map per1,
1846: gl_sets_of_books gsb
1847: WHERE oc.document_id between l_start_rowid and l_end_rowid