APPS.FA_MC_UPG2_PKG dependencies on FA_MC_ADJUSTMENTS

Line 901: INSERT INTO fa_mc_adjustments(

897:
898: -- convert everything in fa_adjustments in the fiscal year being
899: -- converted
900:
901: INSERT INTO fa_mc_adjustments(
902: set_of_books_id,
903: transaction_header_id,
904: source_type_code,
905: adjustment_type,

Line 1059: INSERT INTO fa_mc_adjustments(

1055:
1056: -- convert all balance sheet relevant accounts in the
1057: -- past years as well for the assets being converted.
1058:
1059: INSERT INTO fa_mc_adjustments(
1060: set_of_books_id,
1061: transaction_header_id,
1062: source_type_code,
1063: adjustment_type,

Line 1270: fa_mc_adjustments maj,

1266: mrt.proceeds_of_sale,
1267: mrt.cost_of_removal,
1268: maj.transaction_header_id
1269: FROM
1270: fa_mc_adjustments maj,
1271: fa_deprn_periods dp,
1272: fa_mc_retirements mrt,
1273: fa_retirements rt,
1274: fa_mc_conversion_rates cr

Line 1300: fa_mc_adjustments maj

1296: nvl(sum(decode(maj.debit_credit_flag,
1297: 'DR', maj.adjustment_amount,
1298: 'CR', -1 * maj.adjustment_amount)),0)
1299: FROM
1300: fa_mc_adjustments maj
1301: WHERE
1302: maj.set_of_books_id = p_rsob_id AND
1303: maj.book_type_code = p_book_type_code AND
1304: maj.transaction_header_id = l_trx_id AND

Line 1335: UPDATE fa_mc_adjustments

1331: l_nbv_retired := l_cost_retired - l_rsv_retired;
1332: l_gain_loss := l_proceeds - l_cor - l_nbv_retired +
1333: l_reval_rsv;
1334:
1335: UPDATE fa_mc_adjustments
1336: SET adjustment_amount = l_nbv_retired
1337: WHERE rowid = l_maj_rowid;
1338:
1339: UPDATE fa_mc_retirements

Line 2153: from fa_mc_adjustments

2149: select sum(decode(debit_credit_flag,
2150: 'DR', -1 * adjustment_amount,
2151: adjustment_amount))
2152: into l_ret_reserve
2153: from fa_mc_adjustments
2154: where asset_id = l_asset_id
2155: and book_type_code = l_book_type_code
2156: and set_of_books_id = p_rsob_id
2157: and period_counter_created = l_period_counter