UFN_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETASSOCIATEDPLANS

Returns all associatedplans for a given batch stewardship plan step update record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHSTEWARDSHIPPLANSTEPUPDATEID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETASSOCIATEDPLANS
(
  @BATCHSTEWARDSHIPPLANSTEPUPDATEID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier
)
returns table
as
return
(
  select
    [BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN].ID,
    [BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN].PROSPECTPLANID,
    PROSPECTPLAN.NAME PLANNAME,
    case
      when 
        (
          select count(*) 
          from dbo.UFN_SITEID_MAPFROM_PROSPECTPLANID(PROSPECTPLAN.ID) as PROSPECTPLANSITE 
          where dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, PROSPECTPLANSITE.SITEID) = 1
        ) > 0
      then 1
      else 0
    end as HASSITESECURITY 
  from
    dbo.BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN
  inner join dbo.PROSPECTPLAN
    on PROSPECTPLAN.ID = BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN.PROSPECTPLANID
  where
    [BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN].BATCHSTEWARDSHIPPLANSTEPUPDATEID = @BATCHSTEWARDSHIPPLANSTEPUPDATEID
);