2007: RECOVERY_TYPE_CODE) =
2008: (SELECT REC.Tax_Rate_Code,
2009: REC.Tax_Rate_ID,
2010: REC.Recovery_Type_Code
2011: FROM ZX_Rates_B RATE,
2012: ZX_Rates_B REC
2013: WHERE RATE.Tax_Rate_ID = AID.Tax_Code_ID
2014: AND RATE.Tax_Regime_Code = REC.Tax_Regime_Code
2015: AND RATE.Tax = REC.Tax
2008: (SELECT REC.Tax_Rate_Code,
2009: REC.Tax_Rate_ID,
2010: REC.Recovery_Type_Code
2011: FROM ZX_Rates_B RATE,
2012: ZX_Rates_B REC
2013: WHERE RATE.Tax_Rate_ID = AID.Tax_Code_ID
2014: AND RATE.Tax_Regime_Code = REC.Tax_Regime_Code
2015: AND RATE.Tax = REC.Tax
2016: AND RATE.Tax_Status_Code = REC.Tax_Status_Code