APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_RETIREMENTS

Line 64: ,fa_retirements r

60: ,r.units
61: into l_ret_id_in_corp
62: ,l_units_retired
63: from fa_transaction_headers sth
64: ,fa_retirements r
65: ,fa_book_controls bc
66: where sth.transaction_header_id = RET.th_id_in
67: and sth.asset_id = RET.asset_id
68: and sth.book_type_code = RET.book

Line 96: ,fa_retirements r

92: from fa_distribution_history
93: where retirement_id =
94: (select r.retirement_id
95: from fa_transaction_headers sth
96: ,fa_retirements r
97: where sth.transaction_header_id = RET.th_id_in
98: and sth.asset_id = RET.asset_id
99: and sth.book_type_code = RET.book
100: and r.asset_id = sth.asset_id

Line 352: FROM FA_RETIREMENTS

348:
349: SELECT (MONTHS_BETWEEN(trunc(h_date_retired),
350: trunc(h_date_placed)) / 12) + 1
351: INTO h_years_kept
352: FROM FA_RETIREMENTS
353: WHERE RETIREMENT_ID = h_retirement_id;
354:
355: begin
356: SELECT farecap.itc_recapture_id ,

Line 384: UPDATE fa_retirements fr

380: RAISE fagitc_err;
381: end if;
382:
383: if (ret.mrc_sob_type_code <> 'R') then
384: UPDATE fa_retirements fr
385: SET fr.itc_recaptured = h_recaptured,
386: fr.itc_recapture_id = h_itc_recapture_id
387: WHERE fr.retirement_id = h_retirement_id;
388: else

Line 389: UPDATE fa_retirements_mrc_v fr

385: SET fr.itc_recaptured = h_recaptured,
386: fr.itc_recapture_id = h_itc_recapture_id
387: WHERE fr.retirement_id = h_retirement_id;
388: else
389: UPDATE fa_retirements_mrc_v fr
390: SET fr.itc_recaptured = h_recaptured,
391: fr.itc_recapture_id = h_itc_recapture_id
392: WHERE fr.retirement_id = h_retirement_id;
393: end if;

Line 420: | status in FA_RETIREMENTS table from 'PENDING' to 'PROCESSED'. It |

416: | NAME fagurt |
417: | |
418: | FUNCTION |
419: | It calculates GAIN/LOSS, NBV_RETIRED, STL_DEPRN_AMOUNT. Update the |
420: | status in FA_RETIREMENTS table from 'PENDING' to 'PROCESSED'. It |
421: | also inserts GAIN/LOSS, PROCEEDS_OF_SALE, and COST_OF_REMOVAL to |
422: | FA_ADJUSTMENTS table. |
423: | |
424: | HISTORY 01/12/89 R Rumanang Created |

Line 880: UPDATE fa_retirements fr

876: return(FALSE);
877: end if;
878:
879: if (ret.mrc_sob_type_code <> 'R') then
880: UPDATE fa_retirements fr
881: SET fr.nbv_retired = h_nbv_retired,
882: fr.gain_loss_amount = h_gain_loss,
883: fr.stl_deprn_amount = h_stl_deprn,
884: fr.reval_reserve_retired = h_reval_rsv_retired,

Line 894: UPDATE fa_retirements_mrc_v fr

890: fr.last_updated_by = h_user_id
891: WHERE
892: fr.retirement_id = h_retirement_id;
893: else
894: UPDATE fa_retirements_mrc_v fr
895: SET fr.nbv_retired = h_nbv_retired,
896: fr.gain_loss_amount = h_gain_loss,
897: fr.stl_deprn_amount = h_stl_deprn,
898: fr.reval_reserve_retired = h_reval_rsv_retired,

Line 2931: fa_retirements old_ret,

2927: into h_old_reinst_pc
2928: ,h_old_ret_pc
2929: from fa_transaction_headers trx,
2930: fa_deprn_periods dp1,
2931: fa_retirements old_ret,
2932: fa_deprn_periods dp2
2933: where trx.transaction_header_id = h_old_reinst_trx_id
2934: and dp1.book_type_code = trx.book_type_code
2935: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE

Line 2945: from fa_retirements new_ret

2941: ;
2942:
2943: select dp.period_counter
2944: into h_ret_prorate_pc
2945: from fa_retirements new_ret
2946: ,fa_conventions conv
2947: ,fa_deprn_periods dp
2948: where new_ret.transaction_header_id_in=ret.th_id_in
2949: and conv.prorate_convention_code=new_ret.retirement_prorate_convention

Line 3361: FA_RETIREMENTS rt,

3357: h_dwacq, h_rate_source_rule
3358: FROM FA_FISCAL_YEAR fy1,
3359: FA_FISCAL_YEAR fy2,
3360: FA_BOOKS bk,
3361: FA_RETIREMENTS rt,
3362: FA_CONVENTION_TYPES ctype,
3363: FA_METHODS mt,
3364: FA_BOOK_CONTROLS bc
3365: WHERE rt.date_retired between