DBA Data[Home] [Help]

APPS.XLA_TB_BALANCE_PKG dependencies on GL_CODE_COMBINATIONS

Line 474: FROM gl_code_combinations gcc

470: INTO t_array_ccid
471: FROM xla_tb_balances_gt
472: WHERE code_combination_id NOT IN
473: (SELECT code_combination_id
474: FROM gl_code_combinations gcc
475: ,gl_ledgers gld
476: WHERE gcc.chart_of_accounts_id = gld.chart_of_accounts_id
477: AND gld.ledger_id = p_definition_rec.ledger_id);
478:

Line 2172: ,gl_code_combinations gcc

2168: ,xla_tb_defn_je_sources xjs
2169: ,xla_subledgers xsu
2170: ,xla_transaction_entities_upg PARTITION (AP) xteu
2171: ,xla_ae_lines PARTITION (AP) xal
2172: ,gl_code_combinations gcc
2173: ,( SELECT /*+ NO_MERGE PARALLEL(fsav1) */ id_flex_num
2174: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, 'GL_BALANCING', application_column_name, NULL)) balancing_segment
2175: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, 'GL_ACCOUNT', application_column_name, NULL)) account_segment
2176: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, 'FA_COST_CTR', application_column_name, NULL)) cost_crt_segment

Line 2711: ,gl_code_combinations gcc

2707: ,gcc.segment28
2708: ,gcc.segment29
2709: ,gcc.segment30
2710: FROM xla_tb_balances_gt tdd
2711: ,gl_code_combinations gcc
2712: WHERE gcc.code_combination_id = tdd.code_combination_id;
2713:
2714:
2715: IF (C_LEVEL_STATEMENT>= g_log_level) THEN