USP_SIMPLEDATALIST_PROSPECTPROSPECTPLAN

Returns a list of plans for a prospect.

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTID	uniqueidentifier	IN	Prospect
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_PROSPECTPROSPECTPLAN
                (
                    @PROSPECTID uniqueidentifier = null, 
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as begin
                    set nocount on;
                    select 
                        PROSPECTPLAN.ID as VALUE,
                        PROSPECTPLAN.NAME as LABEL
                    from
                        dbo.PROSPECTPLAN
                        left join dbo.PROSPECTPLANSITE on PROSPECTPLANSITE.PROSPECTPLANID = PROSPECTPLAN.ID
                    where
                        PROSPECTPLAN.PROSPECTID = @PROSPECTID
                        and (dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, PROSPECTPLANSITE.SITEID) = 1)
                    group by
                        PROSPECTPLAN.ID, PROSPECTPLAN.NAME
                    order by
                        PROSPECTPLAN.NAME
                end