DBA Data[Home] [Help]

APPS.CSE_GL_INTERFACE_PKG dependencies on XLA_AE_HEADERS

Line 75: xla_ae_headers xlaeh

71: ,c_gl_transfer_status_code IN VARCHAR2)
72: IS
73: SELECT 'N' --no need to post to gl
74: FROM xla_transaction_entities xlte,
75: xla_ae_headers xlaeh
76: WHERE nvl(xlte.source_id_int_1 , '-99') = c_mtl_transaction_id
77: AND xlte.entity_code = 'MTL_ACCOUNTING_EVENTS'
78: AND xlte.application_id = 707
79: and xlte.ledger_id in (select distinct caiv.ledger_id

Line 319: -- We need to reverse all ledger's in xla_ae_headers

315: */
316:
317: -- ledger_id join ion xlte is only for performance reason.
318: -- xlte is only created for primary ledger but
319: -- We need to reverse all ledger's in xla_ae_headers
320: -- in final mode .
321:
322: CURSOR xla_header_cur( c_ledger_id IN NUMBER
323: , c_mtl_transaction_id IN NUMBER)

Line 332: xla_ae_headers xlaeh

328: xlaeh.application_id,
329: xlte.source_id_int_1,
330: xlte.source_id_int_2
331: FROM xla_transaction_entities xlte,
332: xla_ae_headers xlaeh
333: WHERE xlte.application_id = 707
334: AND xlte.entity_code = 'MTL_ACCOUNTING_EVENTS'
335: AND xlte.ledger_id = c_ledger_id
336: AND nvl(xlte.source_id_int_1, '-99') = c_mtl_transaction_id