APPS.GL_JOURNALS_AUTOCOPY dependencies on GL_JE_SEGMENT_VALUES

Line 467: INSERT INTO gl_je_segment_values

463: t2 =>'TABLE',
464: v2 =>'GL_JE_LINES');
465:
466: -- Insert the new journal segment values
467: INSERT INTO gl_je_segment_values
468: (je_header_id, segment_type_code, segment_value,
469: creation_date, created_by,
470: last_update_date, last_updated_by, last_update_login)
471: SELECT

Line 474: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_je_segment_values sv

470: last_update_date, last_updated_by, last_update_login)
471: SELECT
472: jeh2.je_header_id, sv.segment_type_code, sv.segment_value,
473: sysdate, usr_id, sysdate, usr_id, log_id
474: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_je_segment_values sv
475: WHERE jeh1.je_batch_id = jeb_id
476: AND jeh2.je_batch_id = new_jeb_id
477: AND jeh2.name IN (jeh1.name,
478: substrb(jeh1.name,

Line 489: v2 =>'GL_JE_SEGMENT_VALUES');

485: token_num => 2 ,
486: t1 =>'NUM',
487: v1 =>to_char(temp),
488: t2 =>'TABLE',
489: v2 =>'GL_JE_SEGMENT_VALUES');
490:
491: -- Insert reconciliation data
492: INSERT INTO gl_je_lines_recon
493: (je_header_id, je_line_num, ledger_id,