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

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,
1809: gl_sets_of_books gsb
1810: WHERE oc.document_id between l_start_rowid and l_end_rowid
1811: AND nvl(oc.occurrence_status,'CONFIRMED') <> 'CREATED'

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

2549: -- program of SLA is run for the non posted data
2550: -------------------------------------------------------------------
2551: /* UPDATE jl_br_ar_occurrence_docs_all oc
2552: SET event_id = decode(oc.gl_posted_date, NULL, (SELECT a.event_id
2553: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2554: WHERE sys.org_id = oc.org_id
2555: AND a.entity_id = c.entity_id
2556: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2557: AND c.APPLICATION_ID = 222

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

2559: AND c.LEDGER_ID = sys.set_of_books_id
2560: AND c.SOURCE_ID_INT_1 = oc.document_id
2561: AND c.source_id_int_2 = oc.occurrence_id),NULL) ,
2562: cancel_event_id = decode(oc.occurrence_status, 'CANCELED',(SELECT a1.event_id
2563: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1
2564: WHERE sys1.org_id = oc.org_id
2565: AND a1.entity_id = c1.entity_id
2566: AND a1.event_type_code IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2567: AND c1.APPLICATION_ID = 222

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

2583: END IF;
2584: UPDATE /*+ rowid(jlbr) */ jl_br_ar_distributns_all jlbr
2585: SET event_id = decode(jlbr.accounting_reversal_option, 'Y',
2586: (SELECT a1.event_id
2587: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,
2588: jl_br_ar_occurrence_docs_all oc1
2589: WHERE jlbr.occurrence_id = oc1.occurrence_id
2590: AND sys1.org_id = oc1.org_id
2591: AND a1.entity_id = c1.entity_id

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

2597: AND c1.LEDGER_ID = sys1.set_of_books_id
2598: AND nvl(c1.SOURCE_ID_INT_1,-99) = oc1.document_id
2599: AND nvl(c1.source_id_int_2,-99) = oc1.occurrence_id),
2600: (SELECT a.event_id
2601: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2602: WHERE sys.org_id = jlbr.org_id
2603: AND a.entity_id = c.entity_id
2604: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2605: AND c.APPLICATION_ID = 222

Line 2822: FROM ar_system_parameters_all

2818: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2819: 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');
2820: END IF;
2821: SELECT 1 INTO dummy
2822: FROM ar_system_parameters_all
2823: WHERE global_attribute_category IS NOT NULL
2824: AND global_attribute_category = 'JL.BR.ARXSYSPA.Additional Info'
2825: AND rownum = 1;
2826: