APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on GL_JE_HEADERS

Line 268: FROM GL_JE_HEADERS

264:
265: -- Delete all the existing values
266: DELETE FROM GL_JE_SEGMENT_VALUES
267: WHERE je_header_id IN (SELECT je_header_id
268: FROM GL_JE_HEADERS
269: WHERE je_batch_id = x_je_batch_id);
270:
271: -- Insert distinct segment values
272: INSERT INTO GL_JE_SEGMENT_VALUES

Line 316: gl_je_headers JH,

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
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

Line 499: FROM GL_JE_HEADERS JH

495: num_rows NUMBER;
496: BEGIN
497: DELETE FROM GL_JE_SEGMENT_VALUES SV
498: WHERE SV.je_header_id IN (SELECT JH.je_header_id
499: FROM GL_JE_HEADERS JH
500: WHERE JH.je_batch_id = x_je_batch_id);
501:
502: -- Return the number of distinct balancing and management segment values deleted
503: num_rows := SQL%ROWCOUNT;

Line 528: FROM gl_je_headers jeh, gl_ledgers lgr

524: SELECT bal_seg_column_name,
525: mgt_seg_column_name
526: INTO bsv_colname,
527: msv_colname
528: FROM gl_je_headers jeh, gl_ledgers lgr
529: WHERE jeh.je_header_id = header_id
530: AND lgr.ledger_id = jeh.ledger_id;
531:
532: -- Bug fix 6761820.

Line 638: gl_je_headers JH,

634: 'SEGMENT30',cc.SEGMENT30),
635: sysdate, x_last_updated_by, sysdate,
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

Line 755: FROM gl_je_headers JH,

751: 'SEGMENT29',cc.SEGMENT29,
752: 'SEGMENT30',cc.SEGMENT30),
753: sysdate, x_last_updated_by, sysdate,
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

Line 911: gl_je_headers JEH,

907: 'SEGMENT30',cc.SEGMENT30),
908: sysdate, x_last_updated_by, sysdate,
909: x_last_updated_by, x_last_update_login
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,

Line 912: gl_je_headers SLJEH,

908: sysdate, x_last_updated_by, sysdate,
909: x_last_updated_by, x_last_update_login
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