DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PVT dependencies on FA_MC_RETIREMENTS

Line 3170: from fa_mc_retirements

3166: where retirement_id = p_ret.retirement_id;
3167:
3168: CURSOR c_get_mc_ret_info IS
3169: select -1 * eofy_reserve
3170: from fa_mc_retirements
3171: where retirement_id = p_ret.retirement_id
3172: and set_of_books_id = p_ret.set_of_books_id;
3173:
3174: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';

Line 4063: fa_mc_retirements ret,

4059: cursor c_max_mc_ret_thid is
4060: select max(gth.transaction_header_id)
4061: from fa_transaction_headers gth,
4062: fa_transaction_headers mth,
4063: fa_mc_retirements ret,
4064: fa_mc_books bk
4065: where bk.group_asset_id = p_asset_id
4066: and bk.book_type_code = p_book_type_code
4067: and bk.set_of_books_id = p_set_of_books_id