[Home] [Help]
2175: and th1.transaction_type_code in ('PARTIAL RETIREMENT','FULL RETIREMENT'));
2176:
2177: cursor FA_RET_RSV_MRC is
2178: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
2179: from fa_mc_retirements ret
2180: where ret.book_type_code = h_book_type_code
2181: and ret.asset_id = h_member_asset_id
2182: and ret.set_of_books_id = h_set_of_books_id
2183: and ret.transaction_header_id_in in