DBA Data[Home] [Help]

APPS.FA_MC_UPG2_PKG dependencies on FA_MC_RETIREMENTS

Line 1191: fa_mc_retirements mrt,

1187: maj.transaction_header_id
1188: FROM
1189: fa_mc_adjustments maj,
1190: fa_deprn_periods dp,
1191: fa_mc_retirements mrt,
1192: fa_retirements rt,
1193: fa_mc_conversion_rates cr
1194: WHERE
1195: cr.book_type_code = p_book_type_code AND

Line 1258: UPDATE fa_mc_retirements

1254: UPDATE fa_mc_adjustments
1255: SET adjustment_amount = l_nbv_retired
1256: WHERE rowid = l_maj_rowid;
1257:
1258: UPDATE fa_mc_retirements
1259: SET gain_loss_amount = l_gain_loss,
1260: nbv_retired = l_nbv_retired
1261: WHERE rowid = l_mrt_rowid;
1262: END LOOP;

Line 1298: INSERT INTO fa_mc_retirements(

1294: 'Converting FA_RETIREMENTS records',
1295: 'start');
1296: end if;
1297:
1298: INSERT INTO fa_mc_retirements(
1299: set_of_books_id,
1300: retirement_id,
1301: cost_retired,
1302: status,