DBA Data[Home] [Help]

APPS.XLA_RETRIVE_CCID_PKG dependencies on GL_CODE_COMBINATIONS

Line 215: FROM gl_code_combinations gcc

211: FOR i IN g_seq_context_value.FIRST .. g_seq_context_value.LAST
212: LOOP
213: SELECT NVL (MAX (ROWNUM), 0)
214: INTO l_loop_count
215: FROM gl_code_combinations gcc
216: WHERE gcc.code_combination_id IN (
217: SELECT code_combination_id
218: FROM xla_ae_lines
219: WHERE ae_header_id IN (

Line 269: FROM gl_code_combinations gcc

265: CEIL
266: ( SUM (COUNT (*)) OVER (ORDER BY gcc.code_combination_id ROWS UNBOUNDED PRECEDING)
267: / l_parll_proc_size
268: ) wu
269: FROM gl_code_combinations gcc
270: WHERE gcc.code_combination_id IN (
271: SELECT code_combination_id
272: FROM xla_ae_lines
273: WHERE ae_header_id IN (

Line 796: FROM gl_code_combinations gcc,

792: 'SEGMENT27' seg27_name, gcc.segment28,
793: 'SEGMENT28' seg28_name, gcc.segment29,
794: 'SEGMENT29' seg29_name, gcc.segment30,
795: 'SEGMENT30' seg30_name
796: FROM gl_code_combinations gcc,
797: fnd_id_flex_structures_vl ffsv
798: WHERE gcc.chart_of_accounts_id = ffsv.id_flex_num
799: AND ffsv.application_id = 101
800: AND ffsv.id_flex_code = 'GL#'

Line 910: FROM gl_code_combinations gcc,

906: 'SEGMENT27' seg27_name, gcc.segment28,
907: 'SEGMENT28' seg28_name, gcc.segment29,
908: 'SEGMENT29' seg29_name, gcc.segment30,
909: 'SEGMENT30' seg30_name
910: FROM gl_code_combinations gcc,
911: fnd_id_flex_structures_vl ffsv
912: WHERE gcc.chart_of_accounts_id = ffsv.id_flex_num
913: AND ffsv.application_id = 101
914: AND ffsv.id_flex_code = 'GL#'