APPS.PSA_AP_BC_PVT dependencies on XLA_TRANSACTION_ENTITIES

Line 74: xla_transaction_entities xte

70: xte.source_id_int_3,
71: xte.source_id_int_4,
72: xte.source_id_char_1
73: FROM xla_events xla,
74: xla_transaction_entities xte
75: WHERE NVL(xla.budgetary_control_flag, 'N') ='Y'
76: AND xla.application_id = 200
77: AND xte.entity_code = 'AP_INVOICES'
78: AND xla.event_date BETWEEN p_start_date AND p_end_date

Line 317: xla_transaction_entities t

313: IF (l_curr_invoice_id <> p_tab_fc_dist(i).invoice_id) THEN
314: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting Orphan Events');
315: FOR event_rec IN (SELECT e.*
316: FROM xla_events e,
317: xla_transaction_entities t
318: WHERE e.entity_id = t.entity_id
319: AND t.application_id = 200
320: AND t.entity_code = l_event_source_info.entity_type_code
321: AND NVL(t.source_id_int_1,-99) = l_event_source_info.source_id_int_1 -- Bug 10227913

Line 433: xla_transaction_entities xt,

429: xah.ledger_id,
430: ai.org_id
431: FROM xla_events xe,
432: xla_ae_headers xah,
433: xla_transaction_entities xt,
434: ap_invoices_all ai
435: WHERE xe.application_id = 200
436: AND xah.application_id = 200
437: AND xt.application_id = 200