APPS.GL_CALCULATE_TAX_PKG dependencies on GL_JE_LINES

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 492: INSERT INTO gl_je_lines

488: total_jtax_acc_dr := line_tax_acc_dr;
489: total_jtax_acc_cr := line_tax_acc_cr;
490: END IF;
491:
492: INSERT INTO gl_je_lines
493: (ledger_id, je_header_id, je_line_num,
494: code_combination_id, status,
495: period_name, effective_date,
496: entered_dr, entered_cr,

Line 559: UPDATE gl_je_lines jel

555: total_ltax_acc_cr := total_ltax_acc_cr + line_tax_acc_cr;
556: END IF;
557: END IF;
558:
559: UPDATE gl_je_lines jel
560: SET entered_dr = decode(incl_tax,
561: 'Y', jel.entered_dr - line_tax_dr,
562: jel.entered_dr),
563: entered_cr = decode(incl_tax,

Line 606: FROM gl_je_lines

602: (running_total_dr, running_total_cr,
603: running_total_accounted_dr, running_total_accounted_cr)
604: = (SELECT sum(entered_dr), sum(entered_cr),
605: sum(accounted_dr), sum(accounted_cr)
606: FROM gl_je_lines
607: WHERE je_header_id = header_id)
608: WHERE je_header_id = header_id
609: AND tax_status_code = 'R';
610: ELSE

Line 615: FROM gl_je_lines

611: SELECT sum(entered_dr), sum(entered_cr),
612: sum(accounted_dr), sum(accounted_cr)
613: INTO header_total_dr, header_total_cr,
614: header_total_acc_dr, header_total_acc_cr
615: FROM gl_je_lines
616: WHERE je_header_id = header_id;
617: END IF;
618: END LOOP;
619: