eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_RETIREMENTS

Line 296: from fa_retirements

292:
293: -- Cursor to get member's reserve retired
294: CURSOR c_get_member_rsv_ret IS
295: select nvl(reserve_retired, 0)
296: from fa_retirements
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)

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 307: from fa_retirements

303:
304: CURSOR c_get_member_rsv_rei IS
305: select nvl(reserve_retired, 0)
306: , transaction_header_id_in
307: from fa_retirements
308: where transaction_header_id_out = l_trans_rec.member_transaction_header_id;
309:
310: CURSOR c_mc_get_member_rsv_rei IS
311: 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