APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_CEILINGS

Line 791: from fa_ceilings ce

787: if (h_itc_amount_id is null AND h_ceiling_type = 'RECOVERABLE COST CEILING') then
788: select least(fin_info.cost - fin_info.salvage_value,
789: nvl(ce.limit, fin_info.cost - fin_info.salvage_value))
790: into fin_info.rec_cost
791: from fa_ceilings ce
792: where ce.ceiling_name = fin_info.ceiling_name
793: and fin_info.date_placed_in_svc
794: between ce.start_date
795: and nvl(ce.end_date, fin_info.date_placed_in_svc);

Line 804: from fa_ceilings ce, fa_itc_rates ir

800: h_itc_basis * ir.basis_reduction_rate,
801: nvl(ce.limit, fin_info.cost - fin_info.salvage_value -
802: h_itc_basis * ir.basis_reduction_rate))
803: into fin_info.rec_cost
804: from fa_ceilings ce, fa_itc_rates ir
805: where ir.itc_amount_id = h_itc_amount_id
806: and ce.ceiling_name = fin_info.ceiling_name
807: and fin_info.date_placed_in_svc
808: between ce.start_date