APPS.FA_ADJUSTMENT_PVT dependencies on FA_ADJUSTMENTS_MRC_V

Line 561: from fa_adjustments_mrc_v

557: select nvl(sum(decode(debit_credit_flag,
558: 'DR', adjustment_amount,
559: -adjustment_amount)), 0)
560: into l_deprn_exp_amort_nbv
561: from fa_adjustments_mrc_v
562: where book_type_code = px_asset_hdr_rec.book_type_code
563: and asset_id = px_asset_hdr_rec.asset_id
564: and source_type_code = 'DEPRECIATION'
565: and adjustment_type = 'EXPENSE';

Line 571: from fa_adjustments_mrc_v

567: select nvl(sum(decode(debit_credit_flag,
568: 'CR', adjustment_amount,
569: -adjustment_amount)), 0)
570: into l_reserve_adjustment_amount
571: from fa_adjustments_mrc_v
572: where book_type_code = px_asset_hdr_rec.book_type_code
573: and asset_id = px_asset_hdr_rec.asset_id
574: and source_type_code = 'ADJUSTMENT'
575: and adjustment_type = 'RESERVE';

Line 801: delete from fa_adjustments_mrc_v

797: and adjustment_type in ('COST', 'COST CLEARING');
798:
799: else
800:
801: delete from fa_adjustments_mrc_v
802: where asset_id = px_asset_hdr_rec.asset_id
803: and book_type_code = px_asset_hdr_rec.book_type_code
804: and adjustment_type in ('COST', 'COST CLEARING');
805: