APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on GL_CODE_COMBINATIONS

Line 78: FROM gl_code_combinations CC,

74: 'SEGMENT28',cc.SEGMENT28,
75: 'SEGMENT29',cc.SEGMENT29,
76: 'SEGMENT30',cc.SEGMENT30),
77: sysdate, user_id, sysdate, user_id, login_id
78: FROM gl_code_combinations CC,
79: gl_ledgers LDG,
80: gl_je_lines LINE,
81: gl_row_multipliers X
82: WHERE CC.code_combination_id = LINE.code_combination_id

Line 189: FROM gl_code_combinations CC,

185: 'SEGMENT28',cc.SEGMENT28,
186: 'SEGMENT29',cc.SEGMENT29,
187: 'SEGMENT30',cc.SEGMENT30),
188: sysdate, x_user_id, sysdate, x_user_id, x_login_id
189: FROM gl_code_combinations CC,
190: gl_ledgers LDG,
191: gl_je_lines LINE,
192: gl_row_multipliers X
193: WHERE CC.code_combination_id = LINE.code_combination_id

Line 313: FROM gl_code_combinations CC,

309: 'SEGMENT28',cc.SEGMENT28,
310: 'SEGMENT29',cc.SEGMENT29,
311: 'SEGMENT30',cc.SEGMENT30),
312: sysdate, user_id, sysdate, user_id, login_id
313: FROM gl_code_combinations CC,
314: gl_ledgers LDG,
315: gl_je_lines LINE,
316: gl_je_headers JH,
317: gl_row_multipliers X

Line 414: 'FROM gl_code_combinations cc, gl_row_multipliers ml '||

410: 'decode(ml.multiplier, ' ||
411: '1, '|| bsv_colname || ',' ||
412: msv_colname ||
413: '), sysdate, :user_id, sysdate, :user_id, :login_id ' ||
414: 'FROM gl_code_combinations cc, gl_row_multipliers ml '||
415: 'WHERE cc.code_combination_id = :cc ' ||
416: 'AND ml.multiplier between 1 and 2' ||
417: 'AND NOT EXISTS ' ||
418: '(SELECT 1 ' ||

Line 440: 'FROM gl_code_combinations cc '||

436: ' last_updated_by, last_update_login) ' ||
437: 'SELECT :header_id, ' ||'''B'''||', '
438: ||bsv_colname || ' ' ||
439: ', sysdate, :user_id, sysdate, :user_id, :login_id ' ||
440: 'FROM gl_code_combinations cc '||
441: 'WHERE cc.code_combination_id = :cc ' ||
442: 'AND NOT EXISTS ' ||
443: '(SELECT 1 ' ||
444: 'FROM gl_je_segment_values sv '||

Line 540: 'FROM gl_je_lines jel, gl_code_combinations cc '||

536: 'WHERE sv.segment_type_code = ''B'' ' ||
537: 'AND sv.je_header_id = :header_id ' ||
538: 'AND ((sv.segment_value <> '' '' AND NOT EXISTS ' ||
539: '(SELECT 1 '||
540: 'FROM gl_je_lines jel, gl_code_combinations cc '||
541: 'WHERE jel.je_header_id = :header_id '||
542: 'AND cc.code_combination_id = jel.code_combination_id '||
543: 'AND cc.'|| bsv_colname || ' = sv.segment_value)) ' ||
544: 'OR (sv.segment_value = '' '' and NOT EXISTS ' ||

Line 562: 'FROM gl_je_lines jel, gl_code_combinations cc ' ||

558: 'WHERE sv.segment_type_code = ''M'' ' ||
559: 'AND sv.je_header_id = :header_id ' ||
560: 'AND ((sv.segment_value <> '' '' AND NOT EXISTS ' ||
561: '(SELECT 1 ' ||
562: 'FROM gl_je_lines jel, gl_code_combinations cc ' ||
563: 'WHERE jel.je_header_id = :header_id ' ||
564: 'AND cc.code_combination_id = jel.code_combination_id ' ||
565: 'AND cc.'|| msv_colname || ' = sv.segment_value)) ' ||
566: 'OR (sv.segment_value = '' '' and NOT EXISTS ' ||

Line 640: gl_code_combinations CC,

636: x_last_updated_by, x_last_update_login
637: FROM gl_je_batches JB,
638: gl_je_headers JH,
639: gl_je_lines LINE,
640: gl_code_combinations CC,
641: gl_ledgers LDG,
642: gl_row_multipliers X
643: WHERE JB.posting_run_id = x_prun_id
644: AND JB.status = 'I'

Line 758: gl_code_combinations CC,

754: x_last_updated_by, x_last_update_login
755: FROM gl_je_headers JH,
756: gl_je_lines LINE,
757: gl_ledgers LDG,
758: gl_code_combinations CC,
759: gl_row_multipliers X
760: WHERE JH.je_header_id = x_je_header_id
761: AND JH.display_alc_journal_flag IS NULL
762: AND LINE.je_header_id = x_je_header_id

Line 914: gl_code_combinations CC,

910: FROM gl_je_batches JEB,
911: gl_je_headers JEH,
912: gl_je_headers SLJEH,
913: gl_je_lines SLJEL,
914: gl_code_combinations CC,
915: gl_ledgers LDG,
916: gl_row_multipliers X
917: WHERE JEB.posting_run_id = x_prun_id
918: AND JEB.status = 'I'