APPS.FAP_CALCULATE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

	select	cost - salvage_value -
		(nvl(itc_basis, 0) * nvl( min(ir.basis_reduction_rate), 0))
	into 	rc_no_ceiling
	from	fa_itc_rates 		ir
	where	ir.itc_amount_id = calc_recoverable_cost.itc_amount_id;

Line: 21

	select	least (rc_no_ceiling, nvl (min (ce.limit), rc_no_ceiling))
	into 	recoverable_cost
	from	fa_ceilings 		ce,
		fa_ceiling_types	ct
	where	ce.ceiling_name =
		    decode (ct.ceiling_type,
                            'RECOVERABLE COST CEILING',
				calc_recoverable_cost.ceiling_name,
                            NULL) and
		date_placed_in_service between
		    nvl(ce.start_date, date_placed_in_service) and
		    nvl(ce.end_date, date_placed_in_service)
	and	ct.ceiling_name =  calc_recoverable_cost.ceiling_name;