APPS.XLA_BALANCES_PKG dependencies on GL_LEDGERS

Line 1471: FROM gl_ledgers gle

1467: SELECT gle.chart_of_accounts_id
1468: ,gle.bal_seg_column_name
1469: INTO l_chart_of_accounts_id
1470: ,l_balancing_segment_column
1471: FROM gl_ledgers gle
1472: WHERE gle.ledger_id = i.ledger_id;
1473:
1474: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1475: trace

Line 8687: FROM gl_ledgers xgl

8683: IF p_ledger_id IS NOT NULL
8684: THEN
8685: SELECT chart_of_accounts_id
8686: INTO l_chart_of_accounts_id
8687: FROM gl_ledgers xgl
8688: WHERE xgl.ledger_id = p_ledger_id;
8689:
8690: l_ledger_clause :=
8691: 'AND xbs.ledger_id = ' || p_ledger_id || '

Line 9614: FROM gl_ledgers xgl

9610: ,fnd_concurrent_requests fnd
9611: WHERE xbs.ledger_id IN
9612: (
9613: SELECT xgl.ledger_id
9614: FROM gl_ledgers xgl
9615: WHERE xgl.chart_of_accounts_id = p_chart_of_accounts_id
9616: )
9617: AND xbs.code_combination_id IN
9618: (

Line 9633: FROM gl_ledgers xgl

9629: FROM xla_balance_statuses xbs
9630: WHERE xbs.ledger_id IN
9631: (
9632: SELECT xgl.ledger_id
9633: FROM gl_ledgers xgl
9634: WHERE xgl.chart_of_accounts_id = p_chart_of_accounts_id
9635: )
9636: AND xbs.code_combination_id IN
9637: (

Line 9677: FROM gl_ledgers xgl

9673: FROM xla_balance_statuses xbs
9674: WHERE xbs.ledger_id IN
9675: (
9676: SELECT xgl.ledger_id
9677: FROM gl_ledgers xgl
9678: ,xla_setup_ledgers xsl
9679: WHERE xgl.chart_of_accounts_id = :1
9680: AND xsl.ledger_id = xgl.ledger_id
9681: )

Line 10378: FROM gl_ledgers gll

10374: END IF;
10375:
10376: SELECT gll.currency_code
10377: INTO l_ledger_currency_code
10378: FROM gl_ledgers gll
10379: WHERE gll.ledger_id = p_ledger_id;
10380:
10381: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
10382: trace

Line 10426: FROM xla_gl_ledgers_v xll

10422: END IF;
10423:
10424: SELECT xll.ledger_id
10425: INTO l_ledger_id
10426: FROM xla_gl_ledgers_v xll
10427: WHERE xll.ledger_id = p_ledger_id;
10428:
10429: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
10430: trace