APPS.FA_ASSET_CALC_PVT dependencies on FA_CEILINGS

Line 2541: from fa_ceilings ce

2537:
2538: CURSOR c_get_rec_cost_w_ceiling IS
2539: select least(px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value,
2540: nvl(ce.limit, px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value))
2541: from fa_ceilings ce
2542: where ce.ceiling_name = px_asset_fin_rec_new.ceiling_name
2543: and px_asset_fin_rec_new.date_placed_in_service
2544: between ce.start_date and
2545: nvl(ce.end_date, px_asset_fin_rec_new.date_placed_in_service);

Line 2593: from fa_ceilings ce,

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

Line 2908: from fa_ceilings

2904:
2905: if (px_asset_fin_rec_new.ceiling_name is not null) then
2906: select limit
2907: into l_ceiling_limit
2908: from fa_ceilings
2909: where ceiling_name = px_asset_fin_rec_new.ceiling_name
2910: and px_asset_fin_rec_new.date_placed_in_service between
2911: start_date and nvl(end_date, px_asset_fin_rec_new.date_placed_in_service);
2912: end if;