2909:
2910: CURSOR c_get_bs_amounts(c_period_counter number) IS
2911: select bs.recoverable_cost
2912: , bs.salvage_value
2913: from fa_books_summary bs
2914: where bs.asset_id = p_asset_id
2915: and bs.book_type_code = p_book_type_code
2916: and bs.period_counter = c_period_counter;
2917:
2917:
2918: CURSOR c_get_mc_bs_amounts(c_period_counter number) IS
2919: select bs.recoverable_cost
2920: , bs.salvage_value
2921: from fa_books_summary_mrc_v bs
2922: where bs.asset_id = p_asset_id
2923: and bs.book_type_code = p_book_type_code
2924: and bs.period_counter = c_period_counter;
2925:
2975: l_period_counter := p_period_counter;
2976: end if;
2977:
2978: --
2979: -- eop/eofy amounts are available in FA_BOOKS_SUMMARY table.
2980: --
2981:
2982: if (p_mrc_sob_type_code = 'R') then
2983: FOR i in 1..2 LOOP