APPS.FA_ADJUSTMENT_PVT dependencies on FA_ADJUSTMENTS

Line 533: from fa_adjustments

529: select nvl(sum(decode(debit_credit_flag,
530: 'DR', adjustment_amount,
531: -adjustment_amount)), 0)
532: into l_deprn_exp_amort_nbv
533: from fa_adjustments
534: where book_type_code = px_asset_hdr_rec.book_type_code
535: and asset_id = px_asset_hdr_rec.asset_id
536: and source_type_code = 'DEPRECIATION'
537: and adjustment_type = 'EXPENSE';

Line 543: from fa_adjustments

539: select nvl(sum(decode(debit_credit_flag,
540: 'CR', adjustment_amount,
541: -adjustment_amount)), 0)
542: into l_reserve_adjustment_amount
543: from fa_adjustments
544: where book_type_code = px_asset_hdr_rec.book_type_code
545: and asset_id = px_asset_hdr_rec.asset_id
546: and source_type_code = 'ADJUSTMENT'
547: and adjustment_type = 'RESERVE';

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 794: delete from fa_adjustments

790:
791: -- now update the primary or reporting amounts accordingly
792: if (p_mrc_sob_type_code <> 'R') then
793:
794: delete from fa_adjustments
795: where asset_id = px_asset_hdr_rec.asset_id
796: and book_type_code = px_asset_hdr_rec.book_type_code
797: and adjustment_type in ('COST', 'COST CLEARING');
798:

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: