APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_BR_AR_COLLECTION_DOCS_ALL

Line 1146: from jl_br_ar_collection_docs_all cd,

1142: bo.std_occurrence_code, b.bordero_type, bo.bank_occurrence_type,
1143: cd.document_id, oc.bank_party_id, oc.bordero_id, ract.customer_trx_id,
1144: csc.select_account_id, oc.flag_post_gl, oc.gl_date, cd.org_id,
1145: cd.payment_schedule_id
1146: from jl_br_ar_collection_docs_all cd,
1147: jl_br_ar_occurrence_docs_all oc,
1148: ra_customer_trx_all ract,
1149: jl_br_ar_bank_occurrences bo,
1150: jl_br_ar_select_accounts_all csc,

Line 1802: jl_br_ar_collection_docs_all cd,

1798: ract.trx_number TRX_NUMBER ,
1799: oc.ROWID RID
1800: FROM
1801: jl_br_ar_occurrence_docs_all oc,
1802: jl_br_ar_collection_docs_all cd,
1803: ra_customer_trx_all ract,
1804: jl_br_ar_bank_occurrences bo,
1805: jl_br_ar_select_accounts_all csc,
1806: jl_br_ar_borderos_all b,

Line 2760: jl_br_ar_collection_docs_all cd,

2756: ,'INVOICE' -- EVENT_CLASS_CODE
2757: FROM ra_customer_trx_all trx,
2758: xla_events_gt gt,
2759: ra_cust_trx_line_gl_dist_all ctlgd,
2760: jl_br_ar_collection_docs_all cd,
2761: jl_br_ar_coll_occ_docs_h_v jlh
2762: WHERE gt.entity_code = 'JL_BR_AR_COLL_DOC_OCCS'
2763: AND gt.application_id = l_application_id
2764: AND jlh.jlbr_document_id = gt.source_id_int_1

Line 3119: jl_br_ar_collection_docs_all cd,

3115: --
3116: from
3117: jl_br_ar_occurrence_docs_all od,
3118: jl_br_ar_mc_occ_docs mcod,
3119: jl_br_ar_collection_docs_all cd,
3120: ra_customer_trx_all ct,
3121: gl_ledgers lgr,
3122: gl_date_period_map map,
3123: gl_period_statuses gps,

Line 3472: jl_br_ar_collection_docs_all cd,

3468: --
3469: from
3470: jl_br_ar_occurrence_docs_all od,
3471: jl_br_ar_mc_occ_docs mcod,
3472: jl_br_ar_collection_docs_all cd,
3473: ra_customer_trx_all ct,
3474: gl_ledgers lgr,
3475: gl_date_period_map map,
3476: gl_period_statuses gps,