APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_MC_RETIREMENTS

Line 379: UPDATE fa_mc_retirements fr

375: SET fr.itc_recaptured = h_recaptured,
376: fr.itc_recapture_id = h_itc_recapture_id
377: WHERE fr.retirement_id = h_retirement_id;
378: else
379: UPDATE fa_mc_retirements fr
380: SET fr.itc_recaptured = h_recaptured,
381: fr.itc_recapture_id = h_itc_recapture_id
382: WHERE fr.retirement_id = h_retirement_id
383: AND fr.set_of_books_id = ret.set_of_books_id;

Line 974: UPDATE fa_mc_retirements fr

970: fr.last_updated_by = h_user_id
971: WHERE
972: fr.retirement_id = h_retirement_id;
973: else
974: UPDATE fa_mc_retirements fr
975: SET fr.nbv_retired = nvl(h_g_nbv_retired, h_nbv_retired), --Bug11886090
976: fr.gain_loss_amount = h_gain_loss,
977: fr.stl_deprn_amount = h_stl_deprn,
978: fr.reval_reserve_retired = h_reval_rsv_retired,

Line 3788: fa_mc_retirements old_ret,

3784: into h_old_reinst_pc
3785: ,h_old_ret_pc
3786: from fa_transaction_headers trx,
3787: fa_deprn_periods dp1,
3788: fa_mc_retirements old_ret,
3789: fa_deprn_periods dp2,
3790: fa_conventions conv
3791: where trx.transaction_header_id = h_old_reinst_trx_id
3792: and dp1.book_type_code = trx.book_type_code

Line 3805: from fa_mc_retirements new_ret

3801: and dp2.CALENDAR_PERIOD_CLOSE_DATE;
3802:
3803: select dp.period_counter
3804: into h_ret_prorate_pc
3805: from fa_mc_retirements new_ret
3806: ,fa_conventions conv
3807: ,fa_deprn_periods dp
3808: where new_ret.transaction_header_id_in=ret.th_id_in
3809: and conv.prorate_convention_code=new_ret.retirement_prorate_convention

Line 4294: FA_MC_RETIREMENTS rt,

4290: h_dwacq, h_rate_source_rule
4291: FROM FA_FISCAL_YEAR fy1,
4292: FA_FISCAL_YEAR fy2,
4293: FA_MC_BOOKS bk,
4294: FA_MC_RETIREMENTS rt,
4295: FA_CONVENTION_TYPES ctype,
4296: FA_METHODS mt,
4297: FA_BOOK_CONTROLS bc
4298: WHERE rt.date_retired between