APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_CEILINGS

Line 760: from fa_ceilings ce

756: if (h_itc_amount_id is null AND h_ceiling_type = 'RECOVERABLE COST CEILING') then
757: select least(fin_info.cost - fin_info.salvage_value,
758: nvl(ce.limit, fin_info.cost - fin_info.salvage_value))
759: into fin_info.rec_cost
760: from fa_ceilings ce
761: where ce.ceiling_name = fin_info.ceiling_name
762: and fin_info.date_placed_in_svc
763: between ce.start_date
764: and nvl(ce.end_date, fin_info.date_placed_in_svc);

Line 773: from fa_ceilings ce, fa_itc_rates ir

769: h_itc_basis * ir.basis_reduction_rate,
770: nvl(ce.limit, fin_info.cost - fin_info.salvage_value -
771: h_itc_basis * ir.basis_reduction_rate))
772: into fin_info.rec_cost
773: from fa_ceilings ce, fa_itc_rates ir
774: where ir.itc_amount_id = h_itc_amount_id
775: and ce.ceiling_name = fin_info.ceiling_name
776: and fin_info.date_placed_in_svc
777: between ce.start_date