APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_TRANSACTION_ENTITIES_UPG

Line 1501: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Create the transaction entities, Insert into XLA_TRANSACTION_ENTITIES_UPG, jl_remit_gt,jl_cancel_gt');

1497:
1498: NULL;
1499:
1500: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1501: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Create the transaction entities, Insert into XLA_TRANSACTION_ENTITIES_UPG, jl_remit_gt,jl_cancel_gt');
1502: END IF;
1503:
1504: INSERT all
1505: WHEN (1 = 1) THEN

Line 1506: INTO XLA_TRANSACTION_ENTITIES_UPG

1502: END IF;
1503:
1504: INSERT all
1505: WHEN (1 = 1) THEN
1506: INTO XLA_TRANSACTION_ENTITIES_UPG
1507: (
1508: ENTITY_ID,
1509: APPLICATION_ID,
1510: LEGAL_ENTITY_ID,

Line 1858: xla_transaction_entities_upg xae

1854: and nvl(o2.flag_post_gl,'N') = 'N'))))
1855: ))
1856: And not exists
1857: (SELECT 'Y' FROM
1858: xla_transaction_entities_upg xae
1859: WHERE xae.APPLICATION_ID = 222
1860: And xae.ENTITY_CODE = 'JL_BR_AR_COLL_DOC_OCCS'
1861: And xae.LEDGER_ID = ract.set_of_books_id
1862: And nvl(xae.SOURCE_ID_INT_1,-99) = cd.document_id

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