DBA Data[Home] [Help]

APPS.FA_ASSET_CALC_PVT dependencies on FA_ITC_RATES

Line 3283: fa_itc_rates ir

3279: nvl(ce.limit, px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value -
3280: px_asset_fin_rec_new.itc_basis * ir.basis_reduction_rate))
3281: into px_asset_fin_rec_new.recoverable_cost
3282: from fa_ceilings ce,
3283: fa_itc_rates ir
3284: where ir.itc_amount_id = px_asset_fin_rec_new.itc_amount_id
3285: and ce.ceiling_name = px_asset_fin_rec_new.ceiling_name
3286: and px_asset_fin_rec_new.date_placed_in_service
3287: between ce.start_date and

Line 3294: from fa_itc_rates ir

3290: else
3291: select px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value -
3292: px_asset_fin_rec_new.itc_basis * ir.basis_reduction_rate
3293: into px_asset_fin_rec_new.recoverable_cost
3294: from fa_itc_rates ir
3295: where ir.itc_amount_id = px_asset_fin_rec_new.itc_amount_id;
3296: end if;
3297: end if;
3298:

Line 3657: from fa_itc_rates

3653: select itc_amount_rate,
3654: basis_reduction_rate
3655: into l_itc_amount_rate,
3656: l_basis_reduction_rate
3657: from fa_itc_rates
3658: where itc_amount_id = px_asset_fin_rec_new.itc_amount_id;
3659:
3660: if (px_asset_fin_rec_new.ceiling_name is not null) then
3661: select limit