APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on GL_JE_LINES

Line 80: gl_je_lines LINE,

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
83: AND LDG.ledger_id = LINE.ledger_id
84: AND LINE.je_header_id = x_je_header_id

Line 191: gl_je_lines LINE,

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

Line 315: gl_je_lines LINE,

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
318: WHERE CC.code_combination_id = LINE.code_combination_id
319: AND LDG.ledger_id = LINE.ledger_id

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 545: '(SELECT 1 FROM gl_je_lines jel ' ||

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 ' ||
545: '(SELECT 1 FROM gl_je_lines jel ' ||
546: 'WHERE jel.je_header_id = :header_id ' ||
547: 'AND jel.code_combination_id in (-1,-2,-3))))';
548:
549: END IF;

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 567: '(SELECT 1 FROM gl_je_lines jel ' ||

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 ' ||
567: '(SELECT 1 FROM gl_je_lines jel ' ||
568: 'WHERE jel.je_header_id = :header_id ' ||
569: 'AND jel.code_combination_id in (-1,-2,-3))))';
570:
571: EXECUTE IMMEDIATE delete_msv_stmt USING header_id, header_id, header_id;

Line 639: gl_je_lines LINE,

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
643: WHERE JB.posting_run_id = x_prun_id

Line 756: gl_je_lines LINE,

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
760: WHERE JH.je_header_id = x_je_header_id

Line 913: gl_je_lines SLJEL,

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
917: WHERE JEB.posting_run_id = x_prun_id