DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on GL_LEDGERS

Line 2605: , gl_ledgers gl

2601: -- Retrieve any ledgers that does not enable budgetary control
2602: CURSOR c_invalid_bc_ledgers IS
2603: SELECT gl.ledger_id, gl.name ledger_name
2604: FROM xla_acct_prog_events_gt xpa
2605: , gl_ledgers gl
2606: WHERE xpa.ledger_id = gl.ledger_id
2607: AND enable_budgetary_control_flag = 'N'
2608: AND ROWNUM = 1;
2609:

Line 2617: , xla_gl_ledgers_v xgl

2613: SELECT xgl.ledger_id
2614: , xgl.name ledger_name
2615: , xam.name slam_name
2616: FROM xla_acct_prog_events_gt xap
2617: , xla_gl_ledgers_v xgl
2618: , xla_acctg_methods_tl xam
2619: , xla_acctg_method_rules xar
2620: , xla_aad_line_defn_assgns xal
2621: , xla_line_definitions_b xld

Line 5463: FROM gl_ledgers

5459:
5460: -- get category code of ledger
5461: SELECT ledger_category_code,enable_budgetary_control_flag
5462: INTO l_ledger_category_code,l_enable_bc_flag
5463: FROM gl_ledgers
5464: WHERE ledger_id = l_array_ledgers(i);
5465: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5466: trace
5467: (p_msg => 'ledger category code ='||l_ledger_category_code||'bc flag='||l_enable_bc_flag

Line 5659: FROM gl_ledgers

5655:
5656: -- get category code of ledger
5657: SELECT ledger_category_code,enable_budgetary_control_flag
5658: INTO l_ledger_category_code,l_enable_bc_flag
5659: FROM gl_ledgers
5660: WHERE ledger_id = l_array_ledgers(i);
5661:
5662: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5663: trace