APPS.FA_TRACK_MEMBER_PVT dependencies on FA_MC_RETIREMENTS

Line 4445: from fa_mc_retirements

4441: else
4442:
4443: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)
4444: into h_recognize_gain_loss,h_adj_eofy_reserve,h_reserve_retired
4445: from fa_mc_retirements
4446: where transaction_header_id_in = h_adj_member_trans_header_id
4447: and set_of_books_id = h_set_of_books_id;
4448: end if;
4449:

Line 6189: from fa_mc_retirements ret

6185: and th1.transaction_header_id = ret.transaction_header_id_in);
6186:
6187: cursor FA_RET_RSV_MRC is
6188: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
6189: from fa_mc_retirements ret
6190: where ret.book_type_code = h_book_type_code
6191: and ret.asset_id = h_member_asset_id
6192: and ret.set_of_books_id = h_set_of_books_id
6193: and exists