APPS.XLA_DATAFIXES_PUB dependencies on XLA_TRANSACTION_ENTITIES

Line 294: , xla_transaction_entities e

290: xe.budgetary_control_flag
291: FROM xla_gl_ledgers_v xgl
292: , xla_ae_headers xah
293: , xla_subledgers xsu
294: , xla_transaction_entities e
295: , xla_events xe
296: WHERE xgl.ledger_id = xah.ledger_id
297: AND xsu.application_id = xah.application_id
298: AND xah.event_id = p_event_id

Line 393: , xla_transaction_entities e

389: SELECT xah.ae_header_id BULK COLLECT INTO l_array_je_header_id
390: FROM xla_gl_ledgers_v xgl
391: , xla_ae_headers xah
392: , xla_subledgers xsu
393: , xla_transaction_entities e
394: , xla_events xe
395: WHERE xgl.ledger_id = xah.ledger_id
396: AND xsu.application_id = xah.application_id
397: AND xah.event_id = p_event_id

Line 578: UPDATE xla_transaction_entities

574: AND event_id = x_rev_event_id
575: AND rownum = 1;
576:
577: -- Bug 6964268 Begin
578: UPDATE xla_transaction_entities
579: SET (entity_code
580: , source_id_int_1
581: , source_id_char_1
582: , security_id_int_1

Line 634: FROM xla_transaction_entities

630: ,fnd_global.user_id
631: ,sysdate
632: ,fnd_global.user_id
633: ,fnd_global.user_id
634: FROM xla_transaction_entities
635: WHERE application_id = p_application_id
636: AND entity_id = l_entity_id)
637: WHERE application_id = p_application_id
638: AND entity_id = x_rev_entity_id;

Line 754: UPDATE xla_transaction_entities

750: p_module => l_log_module,
751: p_level => C_LEVEL_STATEMENT);
752: END IF;
753:
754: UPDATE xla_transaction_entities
755: SET (entity_code
756: , source_id_int_1
757: , source_id_char_1
758: , security_id_int_1

Line 810: FROM xla_transaction_entities

806: ,fnd_global.user_id
807: ,sysdate
808: ,fnd_global.user_id
809: ,fnd_global.user_id
810: FROM xla_transaction_entities
811: WHERE application_id = p_application_id
812: AND entity_id = l_entity_id)
813: WHERE application_id = p_application_id
814: AND entity_id = x_new_entity_id;