APPS.XLA_ACCOUNTING_PUB_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 259: FROM XLA_TRANSACTION_ENTITIES

255: ,ENTITY_ID
256: INTO L_APPLICATION_ID
257: ,L_LEDGER_ID
258: ,L_ENTITY_ID
259: FROM XLA_TRANSACTION_ENTITIES
260: WHERE ENTITY_ID = P_ENTITY_ID;
261: ELSE
262: SELECT APPLICATION_ID
263: ,LEDGER_ID

Line 268: FROM XLA_TRANSACTION_ENTITIES

264: ,ENTITY_ID
265: INTO L_APPLICATION_ID
266: ,L_LEDGER_ID
267: ,L_ENTITY_ID
268: FROM XLA_TRANSACTION_ENTITIES
269: WHERE ENTITY_ID = P_ENTITY_ID
270: AND application_id = p_application_id;
271: END IF;
272:

Line 533: FROM xla_transaction_entities xte

529:
530: UPDATE xla_acct_prog_docs_gt xap
531: SET entity_id =
532: (SELECT xte.entity_id
533: FROM xla_transaction_entities xte
534: WHERE xte.application_id = p_application_id
535: AND xte.ledger_id = xap.ledger_id
536: AND xte.entity_code = xap.entity_type_code
537: AND NVL(xte.valuation_method,C_CHAR) = NVL(xap.valuation_method,C_CHAR)

Line 552: FROM xla_transaction_entities xte

548: SELECT count(*) INTO l_count
549: FROM xla_acct_prog_docs_gt xap
550: WHERE entity_id IS NULL
551: OR NOT EXISTS (SELECT entity_id
552: FROM xla_transaction_entities xte
553: WHERE xte.application_id = p_application_id
554: AND xte.entity_id = xap.entity_id);
555:
556: IF (l_count > 0) THEN

Line 577: ,xla_transaction_entities xte

573: INSERT INTO XLA_ACCT_PROG_EVENTS_GT(event_id, ledger_id)
574: SELECT xe.event_id, xte.ledger_id
575: FROM xla_acct_prog_docs_gt xap
576: ,xla_events xe
577: ,xla_transaction_entities xte
578: WHERE xte.application_id = p_application_id
579: AND xte.entity_id = xap.entity_id
580: AND xap.entity_id IS NOT NULL
581: AND xe.application_id = xte.application_id

Line 755: , xla_transaction_entities xte

751: UPDATE xla_acct_prog_events_gt xpa
752: SET (ledger_id) =
753: (SELECT ledger_id
754: FROM xla_events xe
755: , xla_transaction_entities xte
756: WHERE xte.application_id = xe.application_id
757: AND xte.entity_id = xe.entity_id
758: AND xe.application_id = p_application_id
759: AND xe.event_id = xpa.event_id);