APPS.FA_REVALUATION_PVT dependencies on FA_MC_ADJUSTMENTS

Line 967: from fa_mc_adjustments

963:
964: cursor c_mc_get_reval_loss(c_asset_id number,c_book varchar2,c_sob_id number)
965: is
966: select sum(decode(debit_credit_flag,'DR',adjustment_amount,-adjustment_amount))
967: from fa_mc_adjustments
968: where asset_id = c_asset_id
969: and book_type_code = c_book
970: and adjustment_type = 'REVAL LOSS'
971: and set_of_books_id = c_sob_id;

Line 3878: delete from fa_mc_adjustments

3874: and book_type_code = p_asset_hdr_rec.book_type_code
3875: and asset_id = p_asset_hdr_rec.asset_id
3876: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
3877:
3878: delete from fa_mc_adjustments
3879: where transaction_header_id = p_thid
3880: and asset_id = p_asset_hdr_rec.asset_id
3881: and book_type_code = p_asset_hdr_rec.book_type_code
3882: and period_counter_created = l_period_rec.period_counter

Line 4418: INSERT INTO FA_MC_ADJUSTMENTS(

4414: fa_debug_pkg.add(l_calling_fn,'ALC: Creating accounting for new thid: '
4415: , l_trans_rec.transaction_header_id, p_log_level_rec => p_log_level_rec);
4416: end if;
4417:
4418: INSERT INTO FA_MC_ADJUSTMENTS(
4419: SET_OF_BOOKS_ID
4420: , TRANSACTION_HEADER_ID
4421: , SOURCE_TYPE_CODE
4422: , ADJUSTMENT_TYPE

Line 4506: from fa_mc_adjustments

4502: , TRACK_MEMBER_FLAG
4503: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
4504: , SOURCE_LINE_ID
4505: , SOURCE_DEST_CODE
4506: from fa_mc_adjustments
4507: where asset_id = p_asset_hdr_rec.asset_id
4508: and book_type_code = p_asset_hdr_rec.book_type_code
4509: and transaction_header_id = p_thid
4510: and set_of_books_id = p_asset_hdr_rec.set_of_books_id