APPS.IGI_IAC_ADJ_COST_REVAL_PKG dependencies on FA_DEPRN_DETAIL

Line 238: CURSOR c_get_fa_ytd(cp_book_type_code fa_deprn_detail.book_type_code%TYPE,

234: AND iifd.distribution_id = cp_distribution_id
235: AND iifd.active_flag = 'N';
236:
237: -- cursor to retieve the ytd value for a distribution
238: CURSOR c_get_fa_ytd(cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
239: cp_asset_id fa_deprn_detail.asset_id%TYPE,
240: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
241: IS
242: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD

Line 239: cp_asset_id fa_deprn_detail.asset_id%TYPE,

235: AND iifd.active_flag = 'N';
236:
237: -- cursor to retieve the ytd value for a distribution
238: CURSOR c_get_fa_ytd(cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
239: cp_asset_id fa_deprn_detail.asset_id%TYPE,
240: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
241: IS
242: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
243: FROM fa_deprn_detail fdd

Line 240: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)

236:
237: -- cursor to retieve the ytd value for a distribution
238: CURSOR c_get_fa_ytd(cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
239: cp_asset_id fa_deprn_detail.asset_id%TYPE,
240: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
241: IS
242: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
243: FROM fa_deprn_detail fdd
244: WHERE fdd.distribution_id = cp_distribution_id

Line 243: FROM fa_deprn_detail fdd

239: cp_asset_id fa_deprn_detail.asset_id%TYPE,
240: cp_distribution_id fa_deprn_detail.distribution_id%TYPE)
241: IS
242: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
243: FROM fa_deprn_detail fdd
244: WHERE fdd.distribution_id = cp_distribution_id
245: AND fdd.book_type_code = cp_book_type_code
246: AND fdd.asset_id = cp_asset_id
247: AND fdd.period_counter IN (SELECT period_counter