UFN_PROSPECTPLAN_STEPSWITHOUTSTATUS

Returns the steps for a plan.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTPLAN_STEPSWITHOUTSTATUS(@PROSPECTPLANID uniqueidentifier)
            returns table
            as return
                select ID, PLANOUTLINESTEPID, OBJECTIVE, FUNDRAISERID, PROSPECTPLANSTATUSCODEID, EXPECTEDDATE, ACTUALDATE, INTERACTIONTYPECODEID, CONSTITUENTID
                from dbo.INTERACTION
                where PROSPECTPLANID=@PROSPECTPLANID