DBA Data[Home] [Help]

APPS.GL_CALCULATE_TAX_PKG dependencies on GL_JE_LINES

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

494: total_jtax_acc_dr := line_tax_acc_dr;
495: total_jtax_acc_cr := line_tax_acc_cr;
496: END IF;
497:
498: INSERT INTO gl_je_lines
499: (ledger_id, je_header_id, je_line_num,
500: code_combination_id, status,
501: period_name, effective_date,
502: entered_dr, entered_cr,

Line 565: UPDATE gl_je_lines jel

561: total_ltax_acc_cr := total_ltax_acc_cr + line_tax_acc_cr;
562: END IF;
563: END IF;
564:
565: UPDATE gl_je_lines jel
566: SET entered_dr = decode(incl_tax,
567: 'Y', jel.entered_dr - line_tax_dr,
568: jel.entered_dr),
569: entered_cr = decode(incl_tax,

Line 612: FROM gl_je_lines

608: (running_total_dr, running_total_cr,
609: running_total_accounted_dr, running_total_accounted_cr)
610: = (SELECT sum(entered_dr), sum(entered_cr),
611: sum(accounted_dr), sum(accounted_cr)
612: FROM gl_je_lines
613: WHERE je_header_id = header_id)
614: WHERE je_header_id = header_id
615: AND tax_status_code = 'R';
616: ELSE

Line 621: FROM gl_je_lines

617: SELECT sum(entered_dr), sum(entered_cr),
618: sum(accounted_dr), sum(accounted_cr)
619: INTO header_total_dr, header_total_cr,
620: header_total_acc_dr, header_total_acc_cr
621: FROM gl_je_lines
622: WHERE je_header_id = header_id;
623: END IF;
624:
625: /* Added for bug13350390 */

Line 626: retval := gl_je_lines_recon_pkg.insert_gen_line_recon_lines

622: WHERE je_header_id = header_id;
623: END IF;
624:
625: /* Added for bug13350390 */
626: retval := gl_je_lines_recon_pkg.insert_gen_line_recon_lines
627: (
628: X_Je_Header_Id => header_id,
629: X_From_Je_Line_Num => rec_next_line_num,
630: X_Last_Updated_By => user_id,