UFN_ADDPROSPECTPLANSPROCESS_SITES

Returns all sites for a given Add Prospect Plans process instance.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ADDPROSPECTPLANSPROCESSID	uniqueidentifier	IN

Definition

Copy




            create function dbo.UFN_ADDPROSPECTPLANSPROCESS_SITES
            (
                @ADDPROSPECTPLANSPROCESSID uniqueidentifier
            )
            returns table
            as return
                select
                    ID,
                    SITEID
                from 
                    dbo.ADDPROSPECTPLANSPROCESSSITE
                where
                    ADDPROSPECTPLANSPROCESSSITE.ADDPROSPECTPLANSPROCESSID = @ADDPROSPECTPLANSPROCESSID;