APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_TRANSACTION_ENTITIES_UPG

Line 1538: 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');

1534:
1535: NULL;
1536:
1537: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1538: 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');
1539: END IF;
1540:
1541: INSERT all
1542: WHEN (1 = 1) THEN

Line 1543: INTO XLA_TRANSACTION_ENTITIES_UPG

1539: END IF;
1540:
1541: INSERT all
1542: WHEN (1 = 1) THEN
1543: INTO XLA_TRANSACTION_ENTITIES_UPG
1544: (
1545: ENTITY_ID,
1546: APPLICATION_ID,
1547: LEGAL_ENTITY_ID,

Line 1895: xla_transaction_entities_upg xae

1891: and nvl(o2.flag_post_gl,'N') = 'N'))))
1892: ))
1893: And not exists
1894: (SELECT 'Y' FROM
1895: xla_transaction_entities_upg xae
1896: WHERE xae.APPLICATION_ID = 222
1897: And xae.ENTITY_CODE = 'JL_BR_AR_COLL_DOC_OCCS'
1898: And xae.LEDGER_ID = ract.set_of_books_id
1899: And nvl(xae.SOURCE_ID_INT_1,-99) = cd.document_id

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