APPS.FA_FIN_ADJ1_PKG dependencies on FA_CEILINGS

Line 72: from fa_ceilings ce

68: is
69: cursor no_itc_yes_ceiling is
70: select least(bks_cost - bks_salvage_value,
71: nvl(ce.limit, bks_cost - bks_salvage_value))
72: from fa_ceilings ce
73: where ce.ceiling_name = bks_ceiling_name
74: and bks_date_placed_in_service
75: between ce.start_date
76: and nvl(ce.end_date, bks_date_placed_in_service);

Line 89: from fa_ceilings ce, fa_itc_rates ir

85: select least(bks_cost - bks_salvage_value -
86: bks_itc_basis * ir.basis_reduction_rate,
87: nvl(ce.limit, bks_cost - bks_salvage_value -
88: bks_itc_basis * ir.basis_reduction_rate))
89: from fa_ceilings ce, fa_itc_rates ir
90: where ir.itc_amount_id = bks_itc_amount_id
91: and ce.ceiling_name = bks_ceiling_name
92: and bks_date_placed_in_service
93: between ce.start_date