APPS.XLA_FSAH_INT_PVT dependencies on GL_LEDGERS

Line 876: FROM xla_gl_ledgers_v xgl,

872: SELECT xgl.currency_code, xsu.je_source_name, xah.entity_id,
873: xah.ae_header_id, xah.accounting_date, xah.ledger_id,
874: e.legal_entity_id, xah.accrual_reversal_flag,
875: xe.budgetary_control_flag
876: FROM xla_gl_ledgers_v xgl,
877: xla_ae_headers xah,
878: xla_subledgers xsu,
879: xla_transaction_entities e,
880: xla_events xe

Line 903: l_functional_curr xla_gl_ledgers_v.currency_code%TYPE;

899: AND NVL (xah2.gl_transfer_status_code, 'N') IN
900: ('N', 'NT'));
901:
902: -- CAN BE REVERSED ONLY IF IT IS TRANSFERRED
903: l_functional_curr xla_gl_ledgers_v.currency_code%TYPE;
904: l_je_source_name xla_subledgers.je_source_name%TYPE;
905: l_entity_id INTEGER;
906: l_pri_ae_header_id INTEGER;
907: l_pri_gl_date DATE;

Line 1724: FROM gl_ledgers

1720: -- validating the ledger belongs to primary ledger or not
1721: BEGIN
1722: SELECT ledger_category_code
1723: INTO l_ledger_category
1724: FROM gl_ledgers
1725: WHERE ledger_id = l_first_ledger_id;
1726: END;
1727:
1728: IF l_ledger_category <> 'PRIMARY'

Line 1879: FROM gl_ledgers gll, gl_ledger_configurations glc

1875: SELECT glc.completion_status_code, gll.ledger_category_code,
1876: gll.ledger_id
1877: INTO l_ledger_status, l_primary,
1878: l_ledger_id
1879: FROM gl_ledgers gll, gl_ledger_configurations glc
1880: WHERE gll.short_name = p_ledger_short_name AND gll.NAME = glc.NAME;
1881: EXCEPTION
1882: WHEN xla_exceptions_pkg.application_exception
1883: THEN

Line 2037: FROM gl_ledgers

2033:
2034: BEGIN
2035: SELECT ledger_id
2036: INTO l_ledger_id
2037: FROM gl_ledgers
2038: WHERE short_name = p_ledger_short_name;
2039: EXCEPTION
2040: WHEN xla_exceptions_pkg.application_exception
2041: THEN