src/org/openbravo/erpCommon/ad_callouts/SE_Taxes_Active_data.xsql
author RM packaging bot <staff.rm@openbravo.com>
Tue, 28 Jun 2011 10:33:23 +0000
changeset 9542 845811ab032b
parent 9072 79e55dfc8af0
permissions -rw-r--r--
Update AD_MODULE version to 2.50MP31
victor@1818
     1
<?xml version="1.0" encoding="UTF-8"?>
victor@1818
     2
<!--
victor@1818
     3
 *************************************************************************
victor@1818
     4
 * The contents of this file are subject to the Openbravo  Public  License
priya@9072
     5
 * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
victor@1818
     6
 * Version 1.1  with a permitted attribution clause; you may not  use this
victor@1818
     7
 * file except in compliance with the License. You  may  obtain  a copy of
victor@1818
     8
 * the License at http://www.openbravo.com/legal/license.html 
victor@1818
     9
 * Software distributed under the License  is  distributed  on  an "AS IS"
victor@1818
    10
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
victor@1818
    11
 * License for the specific  language  governing  rights  and  limitations
victor@1818
    12
 * under the License. 
victor@1818
    13
 * The Original Code is Openbravo ERP. 
ggi@6701
    14
 * The Initial Developer of the Original Code is Openbravo SLU 
ggi@6701
    15
 * All portions are Copyright (C) 2008 Openbravo SLU 
victor@1818
    16
 * All Rights Reserved. 
victor@1818
    17
 * Contributor(s):  ______________________________________.
victor@1818
    18
 ************************************************************************
victor@1818
    19
-->
victor@1818
    20
victor@1818
    21
victor@1818
    22
<SqlClass name="SETaxesActiveData" package="org.openbravo.erpCommon.ad_callouts">
victor@1818
    23
 <SqlMethod name="getActiveChildrenTaxes" type="preparedStatement" return="multiple">
victor@1818
    24
    <SqlMethodComment></SqlMethodComment>
victor@1818
    25
    <Sql>
victor@1818
    26
      <![CDATA[
victor@1818
    27
        SELECT TC.C_TAX_ID AS Child
victor@1818
    28
		FROM C_TAX TP, C_TAX TC
victor@1818
    29
		WHERE TC.PARENT_TAX_ID = TP.C_TAX_ID
victor@1818
    30
  		AND TC.ISACTIVE = 'Y'
victor@1818
    31
  		AND TP.C_TAX_ID = ?
victor@1818
    32
      ]]>
victor@1818
    33
    </Sql>
victor@1818
    34
    <Parameter name="CTaxParentId"/>
victor@1818
    35
  </SqlMethod>
victor@1818
    36
victor@1818
    37
</SqlClass>