1526: RECOVERY_TYPE_CODE) =
1527: (SELECT REC.Tax_Rate_Code,
1528: REC.Tax_Rate_ID,
1529: REC.Recovery_Type_Code
1530: FROM ZX_Rates_B RATE,
1531: ZX_Rates_B REC
1532: WHERE RATE.Tax_Rate_ID = AID.Tax_Code_ID
1533: AND RATE.Tax_Regime_Code = REC.Tax_Regime_Code
1534: AND RATE.Tax = REC.Tax
1527: (SELECT REC.Tax_Rate_Code,
1528: REC.Tax_Rate_ID,
1529: REC.Recovery_Type_Code
1530: FROM ZX_Rates_B RATE,
1531: ZX_Rates_B REC
1532: WHERE RATE.Tax_Rate_ID = AID.Tax_Code_ID
1533: AND RATE.Tax_Regime_Code = REC.Tax_Regime_Code
1534: AND RATE.Tax = REC.Tax
1535: AND RATE.Tax_Status_Code = REC.Tax_Status_Code