APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 96: FROM ar_system_parameters_all

92:
93: --
94: SELECT set_of_books_id
95: into l_event_source_info.ledger_id
96: FROM ar_system_parameters_all
97: WHERE org_id = l_org_id;
98:
99: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
100: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Getting set of books information '||l_event_source_info.ledger_id);

Line 1844: ar_system_parameters_all sys,

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
1848: AND nvl(oc.occurrence_status,'CONFIRMED') <> 'CREATED'

Line 2590: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys

2586: -- program of SLA is run for the non posted data
2587: -------------------------------------------------------------------
2588: /* UPDATE jl_br_ar_occurrence_docs_all oc
2589: SET event_id = decode(oc.gl_posted_date, NULL, (SELECT a.event_id
2590: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2591: WHERE sys.org_id = oc.org_id
2592: AND a.entity_id = c.entity_id
2593: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2594: AND c.APPLICATION_ID = 222

Line 2600: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1

2596: AND c.LEDGER_ID = sys.set_of_books_id
2597: AND c.SOURCE_ID_INT_1 = oc.document_id
2598: AND c.source_id_int_2 = oc.occurrence_id),NULL) ,
2599: cancel_event_id = decode(oc.occurrence_status, 'CANCELED',(SELECT a1.event_id
2600: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1
2601: WHERE sys1.org_id = oc.org_id
2602: AND a1.entity_id = c1.entity_id
2603: AND a1.event_type_code IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2604: AND c1.APPLICATION_ID = 222

Line 2624: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,

2620: END IF;
2621: UPDATE /*+ rowid(jlbr) */ jl_br_ar_distributns_all jlbr
2622: SET event_id = decode(jlbr.accounting_reversal_option, 'Y',
2623: (SELECT a1.event_id
2624: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,
2625: jl_br_ar_occurrence_docs_all oc1
2626: WHERE jlbr.occurrence_id = oc1.occurrence_id
2627: AND sys1.org_id = oc1.org_id
2628: AND a1.entity_id = c1.entity_id

Line 2638: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys

2634: AND c1.LEDGER_ID = sys1.set_of_books_id
2635: AND nvl(c1.SOURCE_ID_INT_1,-99) = oc1.document_id
2636: AND nvl(c1.source_id_int_2,-99) = oc1.occurrence_id),
2637: (SELECT a.event_id
2638: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2639: WHERE sys.org_id = jlbr.org_id
2640: AND a.entity_id = c.entity_id
2641: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2642: AND c.APPLICATION_ID = 222

Line 2860: FROM ar_system_parameters_all

2856: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2857: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.check_if_upgrade_occs','Start of procedure check_if_upgrade_occs');
2858: END IF;
2859: SELECT 1 INTO dummy
2860: FROM ar_system_parameters_all
2861: WHERE global_attribute_category IS NOT NULL
2862: AND global_attribute_category = 'JL.BR.ARXSYSPA.Additional Info'
2863: AND rownum = 1;
2864: