UFN_CORPORATESTRUCTURESELECTION_GET

Returns all selections for a corporate structure.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN
@ROOTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CORPORATESTRUCTURESELECTION_GET(@APPUSERID uniqueidentifier, @ROOTID uniqueidentifier)
            returns table
            as
            return
            (    
                select SELECTEDID
                from dbo.CORPORATESTRUCTURESELECTION
                where APPUSERID = @APPUSERID
                    and ROOTID = @ROOTID
            );