DBA Data[Home] [Help]

APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on GL_ROW_MULTIPLIERS

Line 81: gl_row_multipliers X

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
83: AND LDG.ledger_id = LINE.ledger_id
84: AND LINE.je_header_id = x_je_header_id
85: AND X.multiplier IN (1,Decode(LDG.mgt_seg_column_name,NULL,NULL,2))

Line 192: gl_row_multipliers X

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
194: AND LDG.ledger_id = LINE.ledger_id
195: AND LINE.je_header_id = x_je_header_id
196: AND LINE.je_line_num = x_je_line_num

Line 317: gl_row_multipliers X

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
318: WHERE CC.code_combination_id = LINE.code_combination_id
319: AND LDG.ledger_id = LINE.ledger_id
320: AND LINE.je_header_id = JH.je_header_id
321: AND JH.je_batch_id = x_je_batch_id

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 642: gl_row_multipliers X

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'
645: AND JH.je_batch_id = JB.je_batch_id
646: AND JH.display_alc_journal_flag = 'N'

Line 759: gl_row_multipliers X

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
763: AND LINE.je_line_num >= x_from_je_line_num

Line 916: gl_row_multipliers X

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'
919: AND JEH.je_batch_id = JEB.je_batch_id
920: AND SLJEH.parent_je_header_id = JEH.je_header_id