[Home] [Help]
297: where transaction_header_id_in = l_trans_rec.member_transaction_header_id;
298:
299: CURSOR c_mc_get_member_rsv_ret IS
300: select nvl(reserve_retired, 0)
301: from fa_retirements_mrc_v
302: where transaction_header_id_in = l_trans_rec.member_transaction_header_id;
303:
304: CURSOR c_get_member_rsv_rei IS
305: select nvl(reserve_retired, 0)
309:
310: CURSOR c_mc_get_member_rsv_rei IS
311: select nvl(reserve_retired, 0)
312: , transaction_header_id_in
313: from fa_retirements_mrc_v
314: where transaction_header_id_out = l_trans_rec.member_transaction_header_id;
315:
316:
317: -- Cursor to get group's reserve retired