UFN_PROSPECTPLAN_ISACTIVEPROSPECT

Returns true when the prospect constituency is active.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTPLAN_ISACTIVEPROSPECT(@PROSPECTPLANID uniqueidentifier) 
            returns bit
            with execute as caller
            as
            begin
                return (select dbo.UFN_CONSTITUENT_ISPROSPECT(PP.PROSPECTID) from dbo.PROSPECTPLAN PP where PP.ID=@PROSPECTPLANID)
            end