APPS.FA_ADJUSTMENT_PVT dependencies on FA_MC_ADJUSTMENTS

Line 711: from fa_mc_adjustments

707: select nvl(sum(decode(debit_credit_flag,
708: 'DR', adjustment_amount,
709: -adjustment_amount)), 0)
710: into l_deprn_exp_amort_nbv
711: from fa_mc_adjustments
712: where book_type_code = px_asset_hdr_rec.book_type_code
713: and asset_id = px_asset_hdr_rec.asset_id
714: and adjustment_type = 'EXPENSE'
715: and set_of_books_id = px_asset_hdr_rec.set_of_books_id;

Line 721: from fa_mc_adjustments

717: select nvl(sum(decode(debit_credit_flag,
718: 'CR', adjustment_amount,
719: -adjustment_amount)), 0)
720: into l_reserve_adjustment_amount
721: from fa_mc_adjustments
722: where book_type_code = px_asset_hdr_rec.book_type_code
723: and asset_id = px_asset_hdr_rec.asset_id
724: and adjustment_type = 'RESERVE'
725: and set_of_books_id = px_asset_hdr_rec.set_of_books_id;

Line 732: from fa_mc_adjustments

728: select nvl(sum(decode(debit_credit_flag,
729: 'DR', adjustment_amount,
730: -adjustment_amount)), 0)
731: into l_bonus_deprn_exp_adj
732: from fa_mc_adjustments
733: where book_type_code = px_asset_hdr_rec.book_type_code
734: and asset_id = px_asset_hdr_rec.asset_id
735: and adjustment_type = 'BONUS EXPENSE'
736: and set_of_books_id = px_asset_hdr_rec.set_of_books_id;

Line 742: from fa_mc_adjustments

738: select nvl(sum(decode(debit_credit_flag,
739: 'CR', adjustment_amount,
740: -adjustment_amount)), 0)
741: into l_bonus_reserve_adj
742: from fa_mc_adjustments
743: where book_type_code = px_asset_hdr_rec.book_type_code
744: and asset_id = px_asset_hdr_rec.asset_id
745: and adjustment_type = 'BONUS RESERVE'
746: and set_of_books_id = px_asset_hdr_rec.set_of_books_id;

Line 753: from fa_mc_adjustments

749: select nvl(sum(decode(debit_credit_flag,
750: 'CR', adjustment_amount,
751: -adjustment_amount)), 0)
752: into l_mvmt_deprn_reval_reserve
753: from fa_mc_adjustments
754: where book_type_code = px_asset_hdr_rec.book_type_code
755: and asset_id = px_asset_hdr_rec.asset_id
756: and adjustment_type = 'REVAL RESERVE';
757:

Line 952: delete from fa_mc_adjustments

948: and adjustment_type in ('COST', 'COST CLEARING');
949:
950: else
951:
952: delete from fa_mc_adjustments
953: where asset_id = px_asset_hdr_rec.asset_id
954: and book_type_code = px_asset_hdr_rec.book_type_code
955: and adjustment_type in ('COST', 'COST CLEARING')
956: and set_of_books_id = px_asset_hdr_rec.set_of_books_id;