[Home] [Help]
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
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.
439: jel.attribute19, jel.attribute20, jel.context2,
440: jel.ussgl_transaction_code,
441: jel.co_third_party,
442: sysdate, usr_id, sysdate, usr_id, log_id
443: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,
444: fnd_currencies curr, gl_je_lines jel
445: WHERE jeh1.je_batch_id = jeb_id
446: AND jeh2.je_batch_id = new_jeb_id
447: AND jeh2.name IN (jeh1.name,
496: rec.jgzz_recon_ref,
497: sysdate, usr_id, sysdate,
498: usr_id, log_id
499: FROM gl_je_batches jeb, gl_je_headers jeh1, gl_je_headers jeh2,
500: gl_ledgers lgr, gl_je_lines jel,
501: gl_code_combinations cc, gl_je_lines_recon rec
502: WHERE jeb.je_batch_id = jeb_id
503: AND jeb.average_journal_flag = 'N'
504: AND jeh1.je_batch_id = jeb_id