APPS.XLA_JE_VALIDATION_PKG dependencies on GL_LEDGERS

Line 3311: JOIN gl_ledgers g

3307: ,NULL period_closing_status -- 4262811
3308: ,h.period_name period_name -- 5136994
3309: ,h.gl_transfer_status_code
3310: FROM xla_ae_headers h
3311: JOIN gl_ledgers g
3312: ON g.ledger_id = h.ledger_id
3313: JOIN gl_period_statuses gp
3314: ON gp.period_name = h.period_name
3315: AND gp.ledger_id = h.ledger_id

Line 5931: ,gl_ledgers gl

5927: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
5928: ,xlo.rounding_rule_code
5929: INTO l_mau, l_rounding_rule_code
5930: FROM xla_ledger_options xlo
5931: ,gl_ledgers gl
5932: ,fnd_currencies fcu
5933: WHERE xlo.application_id = g_application_id
5934: AND xlo.ledger_id = g_trx_ledger_id
5935: AND gl.ledger_id = g_ledger_id

Line 6957: ,gl_ledgers gl

6953: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
6954: ,xlo.rounding_rule_code
6955: INTO l_mau, l_rounding_rule_code
6956: FROM xla_ledger_options xlo
6957: ,gl_ledgers gl
6958: ,fnd_currencies fcu
6959: WHERE xlo.application_id = g_application_id
6960: AND xlo.ledger_id = g_trx_ledger_id
6961: AND gl.ledger_id = g_ledger_id

Line 7815: ,gl_ledgers gl

7811: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
7812: ,xlo.rounding_rule_code
7813: INTO l_mau, l_rounding_rule_code
7814: FROM xla_ledger_options xlo
7815: ,gl_ledgers gl
7816: ,fnd_currencies fcu
7817: WHERE xlo.application_id = g_application_id
7818: AND xlo.ledger_id = g_trx_ledger_id
7819: AND gl.ledger_id = g_ledger_id

Line 8385: ,gl_ledgers gl

8381: SELECT nvl(fcu.minimum_accountable_unit, power(10, -1* fcu.precision))
8382: ,xlo.rounding_rule_code
8383: INTO l_mau, l_rounding_rule_code
8384: FROM xla_ledger_options xlo
8385: ,gl_ledgers gl
8386: ,fnd_currencies fcu
8387: WHERE xlo.application_id = g_application_id
8388: AND xlo.ledger_id = g_trx_ledger_id
8389: AND gl.ledger_id = g_ledger_id

Line 9822: FROM gl_ledgers

9818: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
9819: /*
9820: SELECT suspense_allowed_flag
9821: INTO g_suspense_allowed_flag
9822: FROM gl_ledgers
9823: WHERE ledger_id = g_ledger_id;
9824: */
9825: ELSE
9826: SELECT name

Line 9862: FROM gl_ledgers

9858: g_enable_average_balances_flag,
9859: g_res_encumb_ccid,
9860: g_ledger_category_code,
9861: g_suspense_allowed_flag
9862: FROM gl_ledgers
9863: WHERE ledger_id = g_ledger_id;
9864: END IF;
9865:
9866: IF (g_latest_encumbrance_year IS NULL) THEN