APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_BR_AR_BANK_OCCURRENCES

Line 108: jl_br_ar_bank_occurrences bo

104: SELECT occurrence_id
105: into l_occurrence_id
106: from
107: jl_br_ar_occurrence_docs_all oc,
108: jl_br_ar_bank_occurrences bo
109: WHERE
110: document_id = p_document_id
111: and bo.bank_occurrence_code = oc.bank_occurrence_code
112: and bo.bank_occurrence_type = oc.bank_occurrence_type

Line 136: jl_br_ar_bank_occurrences bo,

132: INTO
133: l_event_source_info.transaction_number
134: FROM jl_br_ar_collection_docs cd,
135: ra_customer_trx_all ract,
136: jl_br_ar_bank_occurrences bo,
137: jl_br_ar_occurrence_docs_all oc
138: WHERE ract.customer_trx_id = cd.customer_trx_id
139: AND ract.org_id = cd.org_id
140: AND cd.document_id = p_document_id

Line 183: jl_br_ar_bank_occurrences bo,

179: INTO
180: l_event_source_info.transaction_number
181: FROM jl_br_ar_collection_docs cd,
182: ra_customer_trx_all ract,
183: jl_br_ar_bank_occurrences bo,
184: jl_br_ar_occurrence_docs_all oc
185: WHERE ract.customer_trx_id = cd.customer_trx_id
186: AND ract.org_id = cd.org_id
187: AND cd.document_id = p_document_id

Line 1149: jl_br_ar_bank_occurrences bo,

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,
1151: jl_br_ar_borderos_all b
1152: where oc.document_id between l_start_id and l_end_id
1153: and nvl(oc.occurrence_status,'CONFIRMED') <> 'CREATED'

Line 1804: jl_br_ar_bank_occurrences bo,

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,
1807: ar_system_parameters_all sys,
1808: gl_date_period_map per1,