DBA Data[Home] [Help]

APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_RETIREMENTS_MRC_V

Line 301: from fa_retirements_mrc_v

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)

Line 313: from fa_retirements_mrc_v

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