DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 271: from fa_mc_deprn_summary

267: and period_counter = l_amort_period;
268:
269: cursor GET_RESERVE_M is
270: select nvl(deprn_reserve,0), nvl(ytd_deprn,0)
271: from fa_mc_deprn_summary
272: where asset_id = px_rule_in.asset_id
273: and period_counter = l_amort_period
274: and set_of_books_id = px_rule_in.set_of_books_id;
275:

Line 522: FA_MC_DEPRN_SUMMARY DS

518: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
519: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
520: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
521: from FA_MC_BOOKS BK,
522: FA_MC_DEPRN_SUMMARY DS
523: where BK.ASSET_ID = DS.ASSET_ID
524: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
525: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER
526: and BK.GROUP_ASSET_ID = px_rule_in.asset_id