APPS.FA_ADJUSTMENT_PVT dependencies on FA_ADJUSTMENTS

Line 655: from fa_adjustments

651: select nvl(sum(decode(debit_credit_flag,
652: 'DR', adjustment_amount,
653: -adjustment_amount)), 0)
654: into l_deprn_exp_amort_nbv
655: from fa_adjustments
656: where book_type_code = px_asset_hdr_rec.book_type_code
657: and asset_id = px_asset_hdr_rec.asset_id
658: and adjustment_type = 'EXPENSE';
659:

Line 664: from fa_adjustments

660: select nvl(sum(decode(debit_credit_flag,
661: 'CR', adjustment_amount,
662: -adjustment_amount)), 0)
663: into l_reserve_adjustment_amount
664: from fa_adjustments
665: where book_type_code = px_asset_hdr_rec.book_type_code
666: and asset_id = px_asset_hdr_rec.asset_id
667: and adjustment_type = 'RESERVE';
668:

Line 674: from fa_adjustments

670: select nvl(sum(decode(debit_credit_flag,
671: 'DR', adjustment_amount,
672: -adjustment_amount)), 0)
673: into l_bonus_deprn_exp_adj
674: from fa_adjustments
675: where book_type_code = px_asset_hdr_rec.book_type_code
676: and asset_id = px_asset_hdr_rec.asset_id
677: and adjustment_type = 'BONUS EXPENSE';
678:

Line 683: from fa_adjustments

679: select nvl(sum(decode(debit_credit_flag,
680: 'CR', adjustment_amount,
681: -adjustment_amount)), 0)
682: into l_bonus_reserve_adj
683: from fa_adjustments
684: where book_type_code = px_asset_hdr_rec.book_type_code
685: and asset_id = px_asset_hdr_rec.asset_id
686: and adjustment_type = 'BONUS RESERVE';
687: -- End Bug 8533933

Line 693: from fa_adjustments

689: select nvl(sum(decode(debit_credit_flag,
690: 'CR', adjustment_amount,
691: -adjustment_amount)), 0)
692: into l_mvmt_deprn_reval_reserve
693: from fa_adjustments
694: where book_type_code = px_asset_hdr_rec.book_type_code
695: and asset_id = px_asset_hdr_rec.asset_id
696: and adjustment_type = 'REVAL RESERVE';
697:

Line 945: delete from fa_adjustments

941:
942: -- now update the primary or reporting amounts accordingly
943: if (p_mrc_sob_type_code <> 'R') then
944:
945: delete from fa_adjustments
946: where asset_id = px_asset_hdr_rec.asset_id
947: and book_type_code = px_asset_hdr_rec.book_type_code
948: and adjustment_type in ('COST', 'COST CLEARING');
949: