UFN_STEWARDSHIPPLANSTEP_ASSOCIATEDPLANS

CREATE function dbo.UFN_STEWARDSHIPPLANSTEP_ASSOCIATEDPLANS
(
    @STEPID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table
as return
    select 
        STEWARDSHIPSTEPASSOCIATEDPLAN.ID,
        STEWARDSHIPSTEPASSOCIATEDPLAN.PROSPECTPLANID,
        PROSPECTPLAN.NAME as 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.STEWARDSHIPSTEPASSOCIATEDPLAN
    inner join dbo.PROSPECTPLAN
        on PROSPECTPLAN.ID = STEWARDSHIPSTEPASSOCIATEDPLAN.PROSPECTPLANID
    where
        STEWARDSHIPSTEPASSOCIATEDPLAN.STEPID = @STEPID;