APPS.GL_CALCULATE_TAX_PKG dependencies on GL_JE_HEADERS

Line 48: FROM gl_je_headers jeh

44: BEGIN
45: -- Lock the header
46: SELECT je_batch_id
47: INTO dummy2
48: FROM gl_je_headers jeh
49: WHERE jeh.je_header_id = header_id
50: FOR UPDATE;
51:
52: -- Lock the batch

Line 64: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr

60: SELECT jeh.tax_status_code, jeh.ledger_id, jeb.org_id,
61: jeb.default_period_name, lgr.currency_code
62: INTO tax_status_code, lgr_id, org_id, per_name,
63: base_currency
64: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr
65: WHERE jeh.je_header_id = header_id
66: AND jeb.je_batch_id = jeh.je_batch_id
67: AND lgr.ledger_id = jeh.ledger_id;
68: EXCEPTION

Line 259: FROM gl_je_headers jeh, fnd_currencies curr, gl_je_lines jel

255: max(jeh.currency_code),
256: max(decode(curr.minimum_accountable_unit,
257: NULL, power(10, -1*curr.precision),
258: curr.minimum_accountable_unit))
259: FROM gl_je_headers jeh, fnd_currencies curr, gl_je_lines jel
260: WHERE jeh.je_header_id = batch_header_id
261: AND curr.currency_code = jeh.currency_code
262: AND jel.je_header_id = jeh.je_header_id;
263:

Line 272: FROM gl_je_headers jeh, fnd_currencies curr, gl_je_lines jel

268: max(jeh.currency_code),
269: max(decode(curr.minimum_accountable_unit,
270: NULL, power(10, -1*curr.precision),
271: curr.minimum_accountable_unit))
272: FROM gl_je_headers jeh, fnd_currencies curr, gl_je_lines jel
273: WHERE jeh.je_batch_id = batch_header_id
274: AND jeh.tax_status_code = 'R'
275: AND curr.currency_code = jeh.currency_code
276: AND jel.je_header_id = jeh.je_header_id

Line 291: FROM gl_je_headers jeh

287:
288: BEGIN
289: SELECT max(decode(jeh.tax_status_code, 'R', '1', '0'))
290: INTO tax_status_code
291: FROM gl_je_headers jeh
292: WHERE jeh.je_batch_id = batch_header_id;
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: fnd_message.set_name('SQLGL', 'GL_CTAX_BAD_BATCH');

Line 597: UPDATE gl_je_headers

593: -- Update the running totals
594: IF ( (tax_level = 'B')
595: AND (nvl(disp_header_id, -1) <> header_id)
596: ) THEN
597: UPDATE gl_je_headers
598: SET tax_status_code = 'T',
599: last_updated_by = user_id,
600: last_update_date = sysdate,
601: last_update_login = login_id,

Line 627: FROM gl_je_headers

623: sum(running_total_accounted_dr),
624: sum(running_total_accounted_cr)
625: INTO batch_total_dr, batch_total_cr,
626: batch_total_acc_dr, batch_total_acc_cr
627: FROM gl_je_headers
628: WHERE je_batch_id = batch_header_id
629: AND je_header_id <> nvl(disp_header_id, -1);
630:
631: IF (disp_header_id IS NOT NULL) THEN