APPS.XLA_JE_VALIDATION_PKG dependencies on GL_LEDGERS

Line 3590: JOIN gl_ledgers g

3586: ,NULL period_closing_status -- 4262811
3587: ,h.period_name period_name -- 5136994
3588: ,h.gl_transfer_status_code
3589: FROM xla_ae_headers h
3590: JOIN gl_ledgers g
3591: ON g.ledger_id = h.ledger_id
3592: JOIN gl_period_statuses gp
3593: ON gp.period_name = h.period_name
3594: AND gp.ledger_id = h.ledger_id

Line 6243: ,gl_ledgers gl

6239: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
6240: ,xlo.rounding_rule_code
6241: INTO l_mau, l_rounding_rule_code
6242: FROM xla_ledger_options xlo
6243: ,gl_ledgers gl
6244: ,fnd_currencies fcu
6245: WHERE xlo.application_id = g_application_id
6246: AND xlo.ledger_id = g_trx_ledger_id
6247: AND gl.ledger_id = g_ledger_id

Line 7340: ,gl_ledgers gl

7336: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
7337: ,xlo.rounding_rule_code
7338: INTO l_mau, l_rounding_rule_code
7339: FROM xla_ledger_options xlo
7340: ,gl_ledgers gl
7341: ,fnd_currencies fcu
7342: WHERE xlo.application_id = g_application_id
7343: AND xlo.ledger_id = g_trx_ledger_id
7344: AND gl.ledger_id = g_ledger_id

Line 8267: ,gl_ledgers gl

8263: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
8264: ,xlo.rounding_rule_code
8265: INTO l_mau, l_rounding_rule_code
8266: FROM xla_ledger_options xlo
8267: ,gl_ledgers gl
8268: ,fnd_currencies fcu
8269: WHERE xlo.application_id = g_application_id
8270: AND xlo.ledger_id = g_trx_ledger_id
8271: AND gl.ledger_id = g_ledger_id

Line 8987: ,gl_ledgers gl

8983: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
8984: ,xlo.rounding_rule_code
8985: INTO l_mau, l_rounding_rule_code
8986: FROM xla_ledger_options xlo
8987: ,gl_ledgers gl
8988: ,fnd_currencies fcu
8989: WHERE xlo.application_id = g_application_id
8990: AND xlo.ledger_id = g_trx_ledger_id
8991: AND gl.ledger_id = g_ledger_id

Line 10507: FROM gl_ledgers

10503: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
10504: /*
10505: SELECT suspense_allowed_flag
10506: INTO g_suspense_allowed_flag
10507: FROM gl_ledgers
10508: WHERE ledger_id = g_ledger_id;
10509: */
10510: ELSE
10511: SELECT name

Line 10547: FROM gl_ledgers

10543: g_enable_average_balances_flag,
10544: g_res_encumb_ccid,
10545: g_ledger_category_code,
10546: g_suspense_allowed_flag
10547: FROM gl_ledgers
10548: WHERE ledger_id = g_ledger_id;
10549: END IF;
10550:
10551: IF (g_latest_encumbrance_year IS NULL) THEN