[Home] [Help]
2199: nvl(faadj.source_type_code, 'DEPRECIATION'),
2200: fadp.period_counter
2201: FROM
2202: fa_distribution_history fadh,
2203: fa_deprn_detail fadd,
2204: fa_deprn_periods fadp,
2205: fa_adjustments faadj
2206: WHERE
2207: fadd.asset_id = h_asset_id
2300: nvl(faadj.source_type_code, 'DEPRECIATION'),
2301: fadp.period_counter
2302: FROM
2303: fa_distribution_history fadh,
2304: fa_deprn_detail_mrc_v fadd,
2305: fa_deprn_periods fadp,
2306: fa_adjustments_mrc_v faadj
2307: WHERE
2308: fadd.asset_id = h_asset_id
3066: end if;
3067:
3068: /* Add the annualized_adj only when it is in a period
3069: * other than period of addition as the annualized amount
3070: * is already factored into deprn_amount in fa_deprn_detail
3071: */
3072: if (h_curr_pd_add = 1) then
3073: -- Fix for Bug #3941213. Don't do this for prior
3074: -- period transfer.
3148: * add to the total backup deprn. The following was required as
3149: * fix for 807256. May not be the most elegant but it works
3150: * without significant redesign of farboe. Always adding
3151: * h_deprn_amount which was the difference between deprn_amount
3152: * in fa_deprn_detail and adjustment_amount in fa_adjustments
3153: * does not work for all the cases. Instead the following
3154: * conditional logic adds the amounts correctly. SNARAYAN
3155: */
3156: