DBA Data[Home] [Help]

APPS.XLA_DATAFIXES_PUB dependencies on XLA_SUBLEDGERS

Line 293: , xla_subledgers xsu

289: xah.ledger_id, e.legal_entity_id, xah.accrual_reversal_flag,
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

Line 315: l_je_source_name xla_subledgers.je_source_name%TYPE;

311: AND xah2.accounting_entry_status_code = C_STATUS_FINAL_CODE
312: AND NVL(xah2.gl_transfer_status_code,'N') IN ('N','NT')); -- can be reversed only if it is transferred
313:
314: l_functional_curr xla_gl_ledgers_v.currency_code%TYPE;
315: l_je_source_name xla_subledgers.je_source_name%TYPE;
316: l_entity_id INTEGER;
317: l_pri_ae_header_id INTEGER;
318: l_pri_gl_date DATE;
319: l_ledger_id INTEGER;

Line 392: , xla_subledgers xsu

388:
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