[Home] [Help]
455:
456: cursor c_get_mc_reserve is
457: select deprn_reserve - ytd_deprn
458: , bonus_deprn_reserve - bonus_ytd_deprn
459: from fa_deprn_summary_mrc_v
460: where book_type_code = X_fin_info_ptr.book
461: and asset_id = X_fin_info_ptr.asset_id
462: and deprn_source_code = 'BOOKS';
463:
1025: if x_mrc_sob_type_code = 'R' then
1026: select deprn_reserve, bonus_deprn_reserve, ytd_deprn
1027: into deprn_summary.deprn_rsv, deprn_summary.bonus_deprn_rsv,
1028: deprn_summary.ytd_deprn
1029: from fa_deprn_summary_mrc_v
1030: where asset_id = X_fin_info_ptr.asset_id
1031: and book_type_code = X_fin_info_ptr.book
1032: and deprn_source_code = 'BOOKS';
1033: else