APPS.FA_MC_UPG2_PKG dependencies on FA_MC_ADJUSTMENTS

Line 840: INSERT INTO fa_mc_adjustments(

836:
837: -- convert everything in fa_adjustments in the fiscal year being
838: -- converted
839:
840: INSERT INTO fa_mc_adjustments(
841: set_of_books_id,
842: transaction_header_id,
843: source_type_code,
844: adjustment_type,

Line 988: INSERT INTO fa_mc_adjustments(

984:
985: -- convert all balance sheet relevant accounts in the
986: -- past years as well for the assets being converted.
987:
988: INSERT INTO fa_mc_adjustments(
989: set_of_books_id,
990: transaction_header_id,
991: source_type_code,
992: adjustment_type,

Line 1189: fa_mc_adjustments maj,

1185: mrt.proceeds_of_sale,
1186: mrt.cost_of_removal,
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

Line 1219: fa_mc_adjustments maj

1215: nvl(sum(decode(maj.debit_credit_flag,
1216: 'DR', maj.adjustment_amount,
1217: 'CR', -1 * maj.adjustment_amount)),0)
1218: FROM
1219: fa_mc_adjustments maj
1220: WHERE
1221: maj.set_of_books_id = p_rsob_id AND
1222: maj.book_type_code = p_book_type_code AND
1223: maj.transaction_header_id = l_trx_id AND

Line 1254: UPDATE fa_mc_adjustments

1250: l_nbv_retired := l_cost_retired - l_rsv_retired;
1251: l_gain_loss := l_proceeds - l_cor - l_nbv_retired +
1252: l_reval_rsv;
1253:
1254: UPDATE fa_mc_adjustments
1255: SET adjustment_amount = l_nbv_retired
1256: WHERE rowid = l_maj_rowid;
1257:
1258: UPDATE fa_mc_retirements

Line 2057: from fa_mc_adjustments

2053: select sum(decode(debit_credit_flag,
2054: 'DR', -1 * adjustment_amount,
2055: adjustment_amount))
2056: into l_ret_reserve
2057: from fa_mc_adjustments
2058: where asset_id = l_asset_id
2059: and book_type_code = l_book_type_code
2060: and set_of_books_id = p_rsob_id
2061: and period_counter_created = l_period_counter