APPS.XLA_ACCOUNTING_PKG dependencies on GL_LEDGERS

Line 2825: , gl_ledgers gl

2821: -- Retrieve any ledgers that does not enable budgetary control
2822: CURSOR c_invalid_bc_ledgers IS
2823: SELECT gl.ledger_id, gl.name ledger_name
2824: FROM xla_acct_prog_events_gt xpa
2825: , gl_ledgers gl
2826: WHERE xpa.ledger_id = gl.ledger_id
2827: AND enable_budgetary_control_flag = 'N'
2828: AND ROWNUM = 1;
2829:

Line 2837: , xla_gl_ledgers_v xgl

2833: SELECT xgl.ledger_id
2834: , xgl.name ledger_name
2835: , xam.name slam_name
2836: FROM xla_acct_prog_events_gt xap
2837: , xla_gl_ledgers_v xgl
2838: , xla_acctg_methods_tl xam
2839: , xla_acctg_method_rules xar
2840: , xla_aad_line_defn_assgns xal
2841: , xla_line_definitions_b xld

Line 5839: FROM gl_ledgers

5835:
5836: -- get category code of ledger
5837: SELECT ledger_category_code,enable_budgetary_control_flag
5838: INTO l_ledger_category_code,l_enable_bc_flag
5839: FROM gl_ledgers
5840: WHERE ledger_id = l_array_ledgers(i);
5841: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5842: trace
5843: (p_msg => 'ledger category code ='||l_ledger_category_code||'bc flag='||l_enable_bc_flag

Line 6036: FROM gl_ledgers

6032:
6033: -- get category code of ledger
6034: SELECT ledger_category_code,enable_budgetary_control_flag
6035: INTO l_ledger_category_code,l_enable_bc_flag
6036: FROM gl_ledgers
6037: WHERE ledger_id = l_array_ledgers(i);
6038:
6039: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6040: trace

Line 8071: FROM gl_ledgers glg

8067: ,xe.last_updated_by = xla_environment_pkg.g_usr_id
8068: ,xe.last_update_login = xla_environment_pkg.g_login_id
8069: ,xe.request_id = g_report_request_id
8070: WHERE xe.event_id IN (SELECT xle.event_id
8071: FROM gl_ledgers glg
8072: ,xla_acctg_methods_b xam
8073: ,xla_acctg_method_rules xamr
8074: ,xla_prod_acct_headers xpah
8075: ,xla_event_types_b xetb