167: nvl(TAX_DD.Period_Counter, -1)
168: FROM FA_DISTRIBUTION_HISTORY DH,
169: FA_ASSET_HISTORY AH,
170: FA_MC_DEPRN_PERIODS DP,
171: FA_MC_DEPRN_DETAIL CORP_DD,
172: FA_MC_DEPRN_DETAIL TAX_DD,
173: fa_mc_book_controls corp_bc,
174: fa_mc_book_controls tax_bc
175: WHERE DH.Book_Type_Code = p_corp_book
168: FROM FA_DISTRIBUTION_HISTORY DH,
169: FA_ASSET_HISTORY AH,
170: FA_MC_DEPRN_PERIODS DP,
171: FA_MC_DEPRN_DETAIL CORP_DD,
172: FA_MC_DEPRN_DETAIL TAX_DD,
173: fa_mc_book_controls corp_bc,
174: fa_mc_book_controls tax_bc
175: WHERE DH.Book_Type_Code = p_corp_book
176: AND DP.Period_Counter = p_tax_period_ctr