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 262: FROM gl_je_headers jeh, fnd_currencies curr, gl_je_lines jel

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

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

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

Line 294: FROM gl_je_headers jeh

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

Line 603: UPDATE gl_je_headers

599: -- Update the running totals
600: IF ( (tax_level = 'B')
601: AND (nvl(disp_header_id, -1) <> header_id)
602: ) THEN
603: UPDATE gl_je_headers
604: SET tax_status_code = 'T',
605: last_updated_by = user_id,
606: last_update_date = sysdate,
607: last_update_login = login_id,

Line 643: FROM gl_je_headers

639: sum(running_total_accounted_dr),
640: sum(running_total_accounted_cr)
641: INTO batch_total_dr, batch_total_cr,
642: batch_total_acc_dr, batch_total_acc_cr
643: FROM gl_je_headers
644: WHERE je_batch_id = batch_header_id
645: AND je_header_id <> nvl(disp_header_id, -1);
646:
647: IF (disp_header_id IS NOT NULL) THEN