APPS.FA_TRACK_MEMBER_PVT dependencies on FA_MC_RETIREMENTS

Line 4601: from fa_mc_retirements

4597: else
4598:
4599: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)
4600: into h_recognize_gain_loss,h_adj_eofy_reserve,h_reserve_retired
4601: from fa_mc_retirements
4602: where transaction_header_id_in = h_adj_member_trans_header_id
4603: and set_of_books_id = h_set_of_books_id;
4604: end if;
4605:

Line 6351: from fa_mc_retirements ret

6347: and th1.transaction_header_id = ret.transaction_header_id_in);
6348:
6349: cursor FA_RET_RSV_MRC is
6350: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
6351: from fa_mc_retirements ret
6352: where ret.book_type_code = h_book_type_code
6353: and ret.asset_id = h_member_asset_id
6354: and ret.set_of_books_id = p_set_of_books_id
6355: and exists

Line 8842: from fa_mc_retirements

8838: cursor GET_RETIREMENTS_MRC(p_thid number) is
8839: select recognize_gain_loss,
8840: nvl(eofy_reserve,0),
8841: (-1)*nvl(reserve_retired,0)
8842: from fa_mc_retirements
8843: where transaction_header_id_in = p_thid
8844: and set_of_books_id = h_set_of_books_id;
8845:
8846: --* Cursor to get reserve retired for reinstatement

Line 8858: from fa_mc_retirements

8854: cursor GET_REINSTATEMENT_MRC(p_thid number) is
8855: select recognize_gain_loss,
8856: nvl(eofy_reserve,0),
8857: nvl(reserve_retired,0)
8858: from fa_mc_retirements
8859: where transaction_header_id_out = p_thid
8860: and set_of_books_id = h_set_of_books_id;
8861:
8862: --* Cursor to query reserve/ytd at addition

Line 10727: from fa_mc_retirements ret

10723: and th1.transaction_header_id = ret.transaction_header_id_in);
10724:
10725: cursor FA_RET_RSV_MRC is
10726: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
10727: from fa_mc_retirements ret
10728: where ret.book_type_code = h_book_type_code
10729: and ret.asset_id = h_member_asset_id
10730: and ret.set_of_books_id = h_set_of_books_id
10731: and exists