DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 1038: -- Update xla_transaction_entities if ledger entity id is updated

1034: END IF;
1035: END IF;
1036:
1037: --
1038: -- Update xla_transaction_entities if ledger entity id is updated
1039: --
1040: IF (l_info.legal_entity_id <> p_legal_entity_id) THEN
1041: UPDATE xla_transaction_entities
1042: SET legal_entity_id = p_legal_entity_id

Line 1041: UPDATE xla_transaction_entities

1037: --
1038: -- Update xla_transaction_entities if ledger entity id is updated
1039: --
1040: IF (l_info.legal_entity_id <> p_legal_entity_id) THEN
1041: UPDATE xla_transaction_entities
1042: SET legal_entity_id = p_legal_entity_id
1043: WHERE application_id = p_application_id -- 4928660
1044: AND entity_id = l_info.entity_id;
1045: END IF;

Line 1215: ,xla_transaction_entities e

1211: ,h.funds_status_code funds_status_code
1212: ,h.packet_id packet_id
1213: ,h.entity_id entity_id
1214: FROM xla_ae_headers h
1215: ,xla_transaction_entities e
1216: WHERE e.application_id = p_application_id
1217: AND e.entity_id = h.entity_id
1218: AND h.application_id = p_application_id
1219: AND h.event_id = p_event_id

Line 3144: ,xla_transaction_entities xte

3140: ,xah.attribute14
3141: ,xah.attribute15
3142: FROM xla_ae_headers xah
3143: ,xla_events xe
3144: ,xla_transaction_entities xte
3145: WHERE xte.entity_id = xah.entity_id
3146: AND xte.application_id = xah.application_id
3147: AND xe.event_id = xah.event_id
3148: AND xe.application_id = xah.application_id