APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_TRANSACTION_ENTITIES_UPG

Line 412: XLA_TRANSACTION_ENTITIES_UPG xte

408: xah.gl_transfer_status_code ,
409: evt.*
410: FROM xla_events_gt evt ,
411: xla_ae_headers xah ,
412: XLA_TRANSACTION_ENTITIES_UPG xte
413: WHERE xah.application_id(+) = evt.application_id
414: AND xah.event_id(+) = evt.event_number
415: AND xte.APPLICATION_ID(+) = xah.application_id
416: AND xte.entity_id(+) = xah.entity_id

Line 1302: UPDATE xla_transaction_entities_upg xtem

1298: -- Need the Caching for the usage of the set up in the XLA_JE_VALIDATION
1299: xla_accounting_cache_pkg.load_application_ledgers(g_application_id , g_ledger_id , l_max_event_date );
1300: g_initialized := 'Y' ;
1301:
1302: UPDATE xla_transaction_entities_upg xtem
1303: SET xtem.valuation_method = ( select xte.valuation_method
1304: from xla_transaction_entities_upg xte ,
1305: xla_events xe
1306: where xe.application_id = g_application_id

Line 1304: from xla_transaction_entities_upg xte ,

1300: g_initialized := 'Y' ;
1301:
1302: UPDATE xla_transaction_entities_upg xtem
1303: SET xtem.valuation_method = ( select xte.valuation_method
1304: from xla_transaction_entities_upg xte ,
1305: xla_events xe
1306: where xe.application_id = g_application_id
1307: and xe.event_id = l_max_event_id
1308: and xte.application_id = g_application_id

Line 1714: FROM xla_events_gt xeg, xla_events xe, xla_transaction_entities_upg xte

1710: SELECT /*+use_nl(xeg,xe,xte) INDEX(xe,XLA_EVENTS_U1) INDEX(xte,XLA_TRANSACTION_ENTITIES_U1)*/
1711: xe.event_status_code ,
1712: xe.event_id ,
1713: xte.entity_code
1714: FROM xla_events_gt xeg, xla_events xe, xla_transaction_entities_upg xte
1715: WHERE xeg.application_id = xe.application_id (+)
1716: AND xeg.event_id = xe.event_id (+)
1717: AND xe.entity_id = xte.entity_id (+)
1718: AND xte.application_id(+) = app_id