DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PVT dependencies on FA_RETIREMENTS_MRC_V

Line 2899: from fa_retirements_mrc_v

2895: where retirement_id = p_ret.retirement_id;
2896:
2897: CURSOR c_get_mc_ret_info IS
2898: select -1 * eofy_reserve
2899: from fa_retirements_mrc_v
2900: where retirement_id = p_ret.retirement_id;
2901:
2902: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';
2903:

Line 3719: fa_retirements_mrc_v ret,

3715: cursor c_max_mc_ret_thid is
3716: select max(gth.transaction_header_id)
3717: from fa_transaction_headers gth,
3718: fa_transaction_headers mth,
3719: fa_retirements_mrc_v ret,
3720: fa_books_mrc_v bk
3721: where bk.group_asset_id = p_asset_id
3722: and bk.book_type_code = p_book_type_code
3723: and ret.asset_id = bk.asset_id