APPS.GL_JOURNAL_IMPORT_TAX_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

PROCEDURE Update_taxes(errbuf	    OUT NOCOPY VARCHAR2,
		       retcode	    OUT NOCOPY VARCHAR2,
		       p_batch_name IN VARCHAR2) IS
l_batch_id NUMBER;

Line: 13

    SELECT je_batch_id
    INTO l_batch_id
    FROM gl_je_batches
    WHERE name = p_batch_name AND
    ROWNUM = 1;

Line: 48

END Update_taxes;

Line: 87

  SELECT je_header_id,name,je_source,tax_status_code,ledger_id
  FROM gl_je_headers
  WHERE je_batch_id = batch_id_in
  FOR UPDATE;

Line: 94

  SELECT period_name,effective_date,status,
    tax_code,amount_includes_tax_flag,tax_code_id,
    attribute9,attribute10
  FROM gl_je_lines
  WHERE je_header_id = header_id_in
  FOR UPDATE;

Line: 104

    SELECT org_id,
      budgetary_control_status, actual_flag,
      approval_status_code, status, name
    INTO l_org_id,
      l_budgetary_control_status, l_actual_flag,
      l_approval_status_code, l_status, l_name
    FROM GL_JE_BATCHES
    WHERE je_batch_id = p_batch_id;

Line: 216

    SELECT name
    INTO l_org_name
    FROM hr_operating_units
    WHERE organization_id = l_org_id;

Line: 338

          UPDATE gl_je_lines
          SET tax_code_id = l_je_line_tax_code_id,
              amount_includes_tax_flag = l_je_line_tax_flag,
              tax_type_code = l_je_line_tax_type_code,
              tax_rounding_rule_code = 'N',
              taxable_line_flag = 'Y'
          WHERE CURRENT OF je_lines;

Line: 369

      UPDATE gl_je_headers
      SET tax_status_code = 'R'
      WHERE CURRENT OF je_headers;

Line: 382

    UPDATE gl_je_batches
    SET org_id = l_org_id
    WHERE je_batch_id = p_batch_id;

Line: 430

  SELECT je_header_id,name,je_source,tax_status_code, ledger_id
  FROM gl_je_headers
  WHERE je_batch_id = batch_id_in
  FOR UPDATE;

Line: 437

  SELECT je_line_num,period_name,effective_date,status,
    tax_code,amount_includes_tax_flag,tax_code_id,
    attribute9,attribute10
  FROM gl_je_lines
  WHERE je_header_id = header_id_in
  FOR UPDATE;

Line: 447

    SELECT org_id,
      budgetary_control_status, actual_flag,
      approval_status_code, status, name
    INTO l_org_id,
      l_budgetary_control_status, l_actual_flag,
      l_approval_status_code, l_status, l_name
    FROM GL_JE_BATCHES
    WHERE je_batch_id = p_batch_id;

Line: 557

    SELECT name
    INTO l_org_name
    FROM hr_operating_units
    WHERE organization_id = l_org_id;

Line: 656

          SELECT tax_code_id, tax_type_code
          INTO l_je_line_tax_code_id, l_je_line_tax_type_code
          FROM GL_TAX_CODES_V
          WHERE org_id = l_org_id AND
            ledger_id = l_ledger_id AND
            tax_code = l_je_line_attribute9 AND
            valid_flag = 'Y' AND
            displayed_flag = 'Y' AND
            enabled_flag = 'Y' AND
            sysdate BETWEEN nvl(start_date,sysdate) AND
            nvl(end_date,sysdate);

Line: 680

          UPDATE gl_je_lines
          SET tax_code_id = l_je_line_tax_code_id,
              amount_includes_tax_flag = l_je_line_tax_flag,
              tax_type_code = l_je_line_tax_type_code,
              tax_rounding_rule_code = 'N',
              taxable_line_flag = 'Y'
          WHERE CURRENT OF je_lines;

Line: 712

      UPDATE gl_je_headers
      SET tax_status_code = 'R'
      WHERE CURRENT OF je_headers;

Line: 726

    UPDATE gl_je_batches
    SET org_id = l_org_id
    WHERE je_batch_id = p_batch_id;