UFN_PLANNEDGIFTADDITION_ISRECEIPTABLE

create function dbo.UFN_PLANNEDGIFTADDITION_ISRECEIPTABLE
(
    @PLANNEDGIFTID uniqueidentifier
)
returns bit
with execute as caller
as begin
  declare @ISRECEIPTABLE bit;
    declare @VEHICLECODE smallint;
  declare @ISREVOCABLE smallint;
  declare @TRUSTHELDOUTSIDE smallint;

  select 
    @VEHICLECODE = VEHICLECODE, 
    @ISREVOCABLE = ISREVOCABLE, 
    @TRUSTHELDOUTSIDE = TRUSTHELDOUTSIDE 
  from dbo.PLANNEDGIFT 
  where ID = @PLANNEDGIFTID;

  if @ISREVOCABLE = 0 and @TRUSTHELDOUTSIDE = 0
    select @ISRECEIPTABLE = dbo.UFN_PLANNEDGIFT_ISRECEIPTABLE(@VEHICLECODE);
  else
    select @ISRECEIPTABLE = 0;

  return @ISRECEIPTABLE;
end