258: AND iifd.distribution_id = cp_distribution_id
259: AND iifd.active_flag = 'N';
260:
261: -- cursor to retieve the ytd value for a distribution
262: CURSOR c_get_fa_ytd(cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
263: cp_asset_id fa_deprn_detail.asset_id%TYPE,
264: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
265: IS
266: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
259: AND iifd.active_flag = 'N';
260:
261: -- cursor to retieve the ytd value for a distribution
262: CURSOR c_get_fa_ytd(cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
263: cp_asset_id fa_deprn_detail.asset_id%TYPE,
264: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
265: IS
266: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
267: FROM fa_deprn_detail fdd
260:
261: -- cursor to retieve the ytd value for a distribution
262: CURSOR c_get_fa_ytd(cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
263: cp_asset_id fa_deprn_detail.asset_id%TYPE,
264: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
265: IS
266: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
267: FROM fa_deprn_detail fdd
268: WHERE fdd.distribution_id = cp_distribution_id
263: cp_asset_id fa_deprn_detail.asset_id%TYPE,
264: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
265: IS
266: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
267: FROM fa_deprn_detail fdd
268: WHERE fdd.distribution_id = cp_distribution_id
269: AND fdd.book_type_code = cp_book_type_code
270: AND fdd.asset_id = cp_asset_id
271: AND fdd.period_counter IN (SELECT period_counter