217: nvl(TAX_DD.Period_Counter, -1)
218: FROM FA_DISTRIBUTION_HISTORY DH,
219: FA_ASSET_HISTORY AH,
220: FA_DEPRN_PERIODS DP,
221: FA_DEPRN_DETAIL CORP_DD,
222: FA_DEPRN_DETAIL TAX_DD
223: WHERE DH.Book_Type_Code = p_corp_book
224: AND DP.Period_Counter = p_tax_period_ctr
225: AND DP.Book_Type_Code = p_tax_book
218: FROM FA_DISTRIBUTION_HISTORY DH,
219: FA_ASSET_HISTORY AH,
220: FA_DEPRN_PERIODS DP,
221: FA_DEPRN_DETAIL CORP_DD,
222: FA_DEPRN_DETAIL TAX_DD
223: WHERE DH.Book_Type_Code = p_corp_book
224: AND DP.Period_Counter = p_tax_period_ctr
225: AND DP.Book_Type_Code = p_tax_book
226: AND AH.Asset_ID = DH.Asset_ID