APPS.XLA_TB_BALANCE_PKG dependencies on XLA_TB_BALANCES_GT

Line 446: FROM xla_tb_balances_gt

442: END IF;
443:
444: SELECT COUNT(1)
445: INTO l_db_cnt
446: FROM xla_tb_balances_gt
447: WHERE definition_code = p_definition_rec.definition_code;
448:
449: IF l_db_cnt = 0 THEN
450:

Line 483: FROM xla_tb_balances_gt

479: --
480: SELECT code_combination_id
481: BULK COLLECT
482: INTO t_array_ccid
483: FROM xla_tb_balances_gt
484: WHERE code_combination_id NOT IN
485: (SELECT code_combination_id
486: FROM gl_code_combinations gcc
487: ,gl_ledgers gld

Line 1066: FROM xla_tb_balances_gt

1062: ,l_created_by
1063: ,l_last_update_date
1064: ,l_last_updated_by
1065: ,l_last_update_login
1066: FROM xla_tb_balances_gt
1067: WHERE definition_code = p_definition_code;
1068:
1069: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1070: trace

Line 1309: FROM xla_tb_balances_gt

1305: MERGE INTO xla_tb_defn_details dt
1306: USING (SELECT code_combination_id
1307: ,balance_date
1308: ,balance_amount
1309: FROM xla_tb_balances_gt
1310: WHERE definition_code = p_definition_code) gt
1311:
1312: ON (dt.code_combination_id = gt.code_combination_id)
1313:

Line 2364: FROM xla_tb_balances_gt tb

2360: p_owner => 'XLA',
2361: p_event_name => 'XLA_AP_TRIAL_UPG_DEFN'))) THEN
2362: SELECT DISTINCT definition_code, ledger_id
2363: BULK COLLECT INTO l_array_defn_code, l_array_ledger_id
2364: FROM xla_tb_balances_gt tb
2365: WHERE definition_code NOT IN
2366: (
2367: SELECT definition_code
2368: FROM xla_tb_definitions_b

Line 2469: FROM xla_tb_balances_gt xtb

2465: ,xla_environment_pkg.g_usr_id
2466: ,SYSDATE
2467: ,xla_environment_pkg.g_usr_id
2468: ,xla_environment_pkg.g_login_id
2469: FROM xla_tb_balances_gt xtb
2470: WHERE NOT EXISTS
2471: (SELECT 1
2472: FROM XLA_GL_LEDGERS
2473: WHERE ledger_id = xtb.ledger_id);

Line 2508: ,xla_tb_balances_gt tb

2504: ,xla_environment_pkg.g_login_Id
2505: ,l.language_code
2506: ,userenv('LANG')
2507: FROM fnd_languages l
2508: ,xla_tb_balances_gt tb
2509: WHERE l.installed_flag in ('I', 'B')
2510: AND NOT EXISTS
2511: (SELECT 1
2512: FROM xla_tb_definitions_tl t

Line 2724: FROM xla_tb_balances_gt tdd

2720: ,gcc.segment27
2721: ,gcc.segment28
2722: ,gcc.segment29
2723: ,gcc.segment30
2724: FROM xla_tb_balances_gt tdd
2725: ,gl_code_combinations gcc
2726: WHERE gcc.code_combination_id = tdd.code_combination_id
2727: AND tdd.definition_code = l_array_defn_code(i)
2728: AND tdd.ledger_id = l_array_ledger_id(i) ; --added for bug1364126