APPS.GL_JOURNALS_AUTOCOPY dependencies on GL_LEDGERS

Line 144: FROM gl_je_headers jeh, gl_ledgers lgr

140: -- Determine the appropriate approval and budgetary control settings
141: SELECT nvl(max(decode(enable_budgetary_control_flag, 'Y', 'Y', null)),'N'),
142: nvl(max(decode(enable_je_approval_flag, 'Y', 'Y', null)), 'N')
143: INTO bc_flag, approval_flag
144: FROM gl_je_headers jeh, gl_ledgers lgr
145: WHERE jeh.je_batch_id = jeb_id
146: AND lgr.ledger_id = jeh.ledger_id;
147:
148: IF (SQL%ROWCOUNT <> 1) THEN

Line 226: FROM gl_je_headers jeh, gl_ledgers lgr

222: SELECT jeh.je_header_id, jeh.ledger_id, jeh.je_category,
223: jeh.currency_code, jeh.currency_conversion_type,
224: jeh.currency_conversion_date, jeh.currency_conversion_rate,
225: lgr.currency_code
226: FROM gl_je_headers jeh, gl_ledgers lgr
227: WHERE jeh.je_batch_id = jeb_id
228: AND lgr.ledger_id = jeh.ledger_id
229: --Commented this as part of bug 7581299.
230: --AND jeh.parent_je_header_id IS NULL; /* See comments above */--Uncommented this as part of bug 7373688.

Line 445: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,

441: jel.no1,--Added this as part of bug6521457
442: jel.ussgl_transaction_code,
443: jel.co_third_party,
444: sysdate, usr_id, sysdate, usr_id, log_id
445: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,
446: fnd_currencies curr, gl_je_lines jel
447: WHERE jeh1.je_batch_id = jeb_id
448: AND jeh2.je_batch_id = new_jeb_id
449: AND jeh2.name IN (jeh1.name,

Line 502: gl_ledgers lgr, gl_je_lines jel,

498: rec.jgzz_recon_ref,
499: sysdate, usr_id, sysdate,
500: usr_id, log_id
501: FROM gl_je_batches jeb, gl_je_headers jeh1, gl_je_headers jeh2,
502: gl_ledgers lgr, gl_je_lines jel,
503: gl_code_combinations cc, gl_je_lines_recon rec
504: WHERE jeb.je_batch_id = jeb_id
505: AND jeb.average_journal_flag = 'N'
506: AND jeh1.je_batch_id = jeb_id