DBA Data[Home] [Help]

APPS.GL_GLCRDR_XMLP_PKG dependencies on GL_JE_HEADERS

Line 38: gl_je_headers jeh,

34: begin
35: select jeb.name, jeb.default_period_name
36: into batch_name, to_period
37: from gl_je_batches jeb,
38: gl_je_headers jeh,
39: gl_je_lines jel
40: where jeb.je_batch_id = batch_id
41: and jeh.je_batch_id = jeb.je_batch_id
42: and (jeh.display_alc_journal_flag is null or jeh.display_alc_journal_flag = 'Y')

Line 60: from gl_import_references jir, gl_je_headers jeh

56: begin
57:
58: select jir.reference_3, jir.reference_1, jir.reference_4
59: into s_header_id, s_consolidation_id, s_ccid
60: from gl_import_references jir, gl_je_headers jeh
61: where jeh.je_batch_id = batch_id
62: and jir.je_header_id = jeh.je_header_id
63: and rownum < 2;
64:

Line 80: from gl_je_headers jeh

76: ccid := to_number(s_ccid);
77: begin
78: select jeh.ledger_id
79: into from_ledid
80: from gl_je_headers jeh
81: where jeh.je_header_id = header_id;
82:
83: EXCEPTION
84: when NO_DATA_FOUND OR INVALID_NUMBER OR VALUE_ERROR then