APPS.FA_TRACK_MEMBER_PVT dependencies on FA_RETIREMENTS_MRC_V

Line 8572: from fa_retirements_mrc_v

8568: cursor GET_RETIREMENTS_MRC(p_thid number) is
8569: select recognize_gain_loss,
8570: nvl(eofy_reserve,0),
8571: (-1)*nvl(reserve_retired,0)
8572: from fa_retirements_mrc_v
8573: where transaction_header_id_in = p_thid;
8574:
8575: --* Cursor to get reserve retired for reinstatement
8576: cursor GET_REINSTATEMENT(p_thid number) is

Line 8587: from fa_retirements_mrc_v

8583: cursor GET_REINSTATEMENT_MRC(p_thid number) is
8584: select recognize_gain_loss,
8585: nvl(eofy_reserve,0),
8586: nvl(reserve_retired,0)
8587: from fa_retirements_mrc_v
8588: where transaction_header_id_out = p_thid;
8589:
8590: --* Cursor to query reserve/ytd at addition
8591: cursor GET_RESERVE_AT_ADDITION(p_asset_id number, p_period_counter number) is

Line 10398: from fa_retirements_mrc_v ret

10394: and th1.transaction_header_id = ret.transaction_header_id_in);
10395:
10396: cursor FA_RET_RSV_MRC is
10397: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
10398: from fa_retirements_mrc_v ret
10399: where ret.book_type_code = h_book_type_code
10400: and ret.asset_id = h_member_asset_id
10401: and exists
10402: (select th1.transaction_header_id