DBA Data[Home] [Help]

APPS.XLA_DATAFIXES_PUB dependencies on XLA_SUBLEDGERS

Line 484: xla_subledgers xsu,

480: FROM XLA_LEDGER_OPTIONS opt,
481: XLA_LEDGER_RELATIONSHIPS_V rs,
482: xla_gl_ledgers_v gl,
483: xla_ae_headers xah,
484: xla_subledgers xsu,
485: xla_events xle,
486: xla_transaction_entities xte
487: WHERE opt.LEDGER_ID = xah.ledger_id
488: AND opt.APPLICATION_ID = xah.application_id

Line 534: l_je_source_name xla_subledgers.je_source_name%TYPE;

530: --Added bug#8344908
531:
532:
533: l_functional_curr xla_gl_ledgers_v.currency_code%TYPE;
534: l_je_source_name xla_subledgers.je_source_name%TYPE;
535: l_entity_id INTEGER;
536: l_pri_ae_header_id INTEGER;
537: l_pri_gl_date DATE;
538: l_ledger_id INTEGER;

Line 664: xla_subledgers xsu,

660: FROM XLA_LEDGER_OPTIONS opt,
661: XLA_LEDGER_RELATIONSHIPS_V rs,
662: xla_gl_ledgers_v gl,
663: xla_ae_headers xah,
664: xla_subledgers xsu,
665: xla_events xle,
666: xla_transaction_entities xte
667: WHERE opt.LEDGER_ID = xah.ledger_id
668: AND opt.APPLICATION_ID = xah.application_id

Line 1617: ,xla_subledgers xsl

1613: ,xtb.definition_code
1614: FROM xla_ae_headers xah
1615: ,xla_tb_defn_je_sources xtbje
1616: ,xla_tb_definitions_vl xtb
1617: ,xla_subledgers xsl
1618: WHERE xah.application_id = p_application_id
1619: AND xah.event_id = p_event_id
1620: AND xtb.ledger_id = xah.ledger_id
1621: AND xtb.definition_code = xtbje.definition_code