USP_GET_MODULEAUTHORIZATIONDETAIL

      CREATE PROCEDURE dbo.USP_GET_MODULEAUTHORIZATIONDETAIL
      (
          @CLIENTID int,
          @MODULENAME varchar(150)
      ) 
      AS
      BEGIN
          -- SET NOCOUNT ON added to prevent extra result sets from

          -- interfering with SELECT statements.

          SET NOCOUNT ON;

          declare @LISTCLIENTUSERSUSERTASK table(TASKGUID uniqueidentifier, CLIENTSITESID int, ISSITETASK int)
          insert into @LISTCLIENTUSERSUSERTASK(TASKGUID,CLIENTSITESID,ISSITETASK) exec USP_DATALIST_CLIENTUSERS_USERTASKS @CLIENTUSERSID=@CLIENTID

        select GUID as Guid, NAME as Name from APPLICATIONTASKS where GUID in(select TASKGUID from @LISTCLIENTUSERSUSERTASK where TASKGUID in(
            select AT1.GUID from APPLICATIONTASKS AT
          inner join APPLICATIONTASKS AT1 on AT.ID = AT1.[ParentID] where AT.NAME = @MODULENAME))
      END