APPS.XLA_BALANCES_PKG dependencies on GL_LEDGERS

Line 1482: FROM gl_ledgers gle

1478: SELECT gle.chart_of_accounts_id
1479: ,gle.bal_seg_column_name
1480: INTO l_chart_of_accounts_id
1481: ,l_balancing_segment_column
1482: FROM gl_ledgers gle
1483: WHERE gle.ledger_id = i.ledger_id;
1484:
1485: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1486: trace

Line 8508: FROM gl_ledgers xgl

8504: IF p_ledger_id IS NOT NULL
8505: THEN
8506: SELECT chart_of_accounts_id
8507: INTO l_chart_of_accounts_id
8508: FROM gl_ledgers xgl
8509: WHERE xgl.ledger_id = p_ledger_id;
8510:
8511: l_ledger_clause :=
8512: 'AND xbs.ledger_id = ' || p_ledger_id || '

Line 9432: FROM gl_ledgers xgl

9428: ,fnd_concurrent_requests fnd
9429: WHERE xbs.ledger_id IN
9430: (
9431: SELECT xgl.ledger_id
9432: FROM gl_ledgers xgl
9433: WHERE xgl.chart_of_accounts_id = p_chart_of_accounts_id
9434: )
9435: AND xbs.code_combination_id IN
9436: (

Line 9451: FROM gl_ledgers xgl

9447: FROM xla_balance_statuses xbs
9448: WHERE xbs.ledger_id IN
9449: (
9450: SELECT xgl.ledger_id
9451: FROM gl_ledgers xgl
9452: WHERE xgl.chart_of_accounts_id = p_chart_of_accounts_id
9453: )
9454: AND xbs.code_combination_id IN
9455: (

Line 9495: FROM gl_ledgers xgl

9491: FROM xla_balance_statuses xbs
9492: WHERE xbs.ledger_id IN
9493: (
9494: SELECT xgl.ledger_id
9495: FROM gl_ledgers xgl
9496: ,xla_setup_ledgers xsl
9497: WHERE xgl.chart_of_accounts_id = :1
9498: AND xsl.ledger_id = xgl.ledger_id
9499: )

Line 10189: FROM gl_ledgers gll

10185: END IF;
10186:
10187: SELECT gll.currency_code
10188: INTO l_ledger_currency_code
10189: FROM gl_ledgers gll
10190: WHERE gll.ledger_id = p_ledger_id;
10191:
10192: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
10193: trace

Line 10237: FROM xla_gl_ledgers_v xll

10233: END IF;
10234:
10235: SELECT xll.ledger_id
10236: INTO l_ledger_id
10237: FROM xla_gl_ledgers_v xll
10238: WHERE xll.ledger_id = p_ledger_id;
10239:
10240: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
10241: trace