APPS.GL_JE_HEADERS_PKG dependencies on GL_LEDGERS

Line 145: from gl_ledgers lgr

141: (select decode(jeh.currency_code,
142: 'STAT', new_effective_date,
143: lgr.currency_code, new_effective_date,
144: jeh.currency_conversion_date)
145: from gl_ledgers lgr
146: where lgr.ledger_id = jeh.ledger_id),
147: accrual_rev_effective_date
148: = (select decode(jeh.accrual_rev_status,
149: null, ps.start_date,

Line 217: FROM gl_je_headers jeh, gl_ledgers lgr

213: CURSOR convert_headers IS
214: SELECT jeh.je_header_id, jeh.currency_code, jeh.actual_flag,
215: jeh.currency_conversion_type, jeh.je_category,
216: jeh.ledger_id, lgr.currency_code, jeh.reversed_je_header_id
217: FROM gl_je_headers jeh, gl_ledgers lgr
218: WHERE jeh.je_batch_id = batch_id
219: AND lgr.ledger_id = jeh.ledger_id
220: ORDER BY jeh.name || to_char(jeh.ledger_id)
221: FOR UPDATE OF jeh.default_effective_date, jeh.period_name,

Line 231: FROM gl_je_headers jeh, gl_ledgers lgr

227: CURSOR convert_header_range IS
228: SELECT jeh.je_header_id, jeh.currency_code, jeh.actual_flag,
229: jeh.currency_conversion_type, jeh.je_category,
230: jeh.ledger_id, lgr.currency_code, jeh.reversed_je_header_id
231: FROM gl_je_headers jeh, gl_ledgers lgr
232: WHERE jeh.je_batch_id = batch_id
233: AND lgr.ledger_id = jeh.ledger_id
234: AND jeh.name > (SELECT name || to_char(ledger_id)
235: FROM gl_je_headers

Line 331: FROM gl_je_headers jeh, gl_ledgers lgr

327: SELECT jeh.je_category, jeh.actual_flag, jeh.ledger_id,
328: lgr.currency_code, jeh.reversed_je_header_id
329: INTO cje_category, cje_actual_flag, cledger_id,
330: cfunct_curr, crev_jeh_id
331: FROM gl_je_headers jeh, gl_ledgers lgr
332: WHERE jeh.je_header_id = header_id
333: AND lgr.ledger_id = jeh.ledger_id;
334:
335: -- If the user has just changed the currency to stat, then

Line 742: gl_ledgers_pkg.select_columns(

738: error_name := '';
739:
740: -- Get the ledger information
741: BEGIN
742: gl_ledgers_pkg.select_columns(
743: ledger_id,
744: ledger_name);
745: EXCEPTION
746: WHEN NO_DATA_FOUND THEN