DBA Data[Home] [Help]

APPS.FA_ASSET_CALC_PVT dependencies on FA_ITC_RATES

Line 2594: fa_itc_rates ir

2590: nvl(ce.limit, px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value -
2591: px_asset_fin_rec_new.itc_basis * ir.basis_reduction_rate))
2592: into px_asset_fin_rec_new.recoverable_cost
2593: from fa_ceilings ce,
2594: fa_itc_rates ir
2595: where ir.itc_amount_id = px_asset_fin_rec_new.itc_amount_id
2596: and ce.ceiling_name = px_asset_fin_rec_new.ceiling_name
2597: and px_asset_fin_rec_new.date_placed_in_service
2598: between ce.start_date and

Line 2605: from fa_itc_rates ir

2601: else
2602: select px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value -
2603: px_asset_fin_rec_new.itc_basis * ir.basis_reduction_rate
2604: into px_asset_fin_rec_new.recoverable_cost
2605: from fa_itc_rates ir
2606: where ir.itc_amount_id = px_asset_fin_rec_new.itc_amount_id;
2607: end if;
2608: end if;
2609:

Line 2902: from fa_itc_rates

2898: select itc_amount_rate,
2899: basis_reduction_rate
2900: into l_itc_amount_rate,
2901: l_basis_reduction_rate
2902: from fa_itc_rates
2903: where itc_amount_id = px_asset_fin_rec_new.itc_amount_id;
2904:
2905: if (px_asset_fin_rec_new.ceiling_name is not null) then
2906: select limit