APPS.FA_ASSET_CALC_PVT dependencies on FA_CEILINGS

Line 3230: from fa_ceilings ce

3226:
3227: CURSOR c_get_rec_cost_w_ceiling IS
3228: select least(px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value,
3229: nvl(ce.limit, px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value))
3230: from fa_ceilings ce
3231: where ce.ceiling_name = px_asset_fin_rec_new.ceiling_name
3232: and px_asset_fin_rec_new.date_placed_in_service
3233: between ce.start_date and
3234: nvl(ce.end_date, px_asset_fin_rec_new.date_placed_in_service);

Line 3282: from fa_ceilings ce,

3278: px_asset_fin_rec_new.itc_basis * ir.basis_reduction_rate,
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

Line 3663: from fa_ceilings

3659:
3660: if (px_asset_fin_rec_new.ceiling_name is not null) then
3661: select limit
3662: into l_ceiling_limit
3663: from fa_ceilings
3664: where ceiling_name = px_asset_fin_rec_new.ceiling_name
3665: and px_asset_fin_rec_new.date_placed_in_service between
3666: start_date and nvl(end_date, px_asset_fin_rec_new.date_placed_in_service);
3667: end if;