Begin
		If (@PLocationid =0) 
		Begin
			SELECT  @PUserName=A.USER_LOGIN,@PUserFullName=A.USER_NAME, @PRoleName= B.ROLE_NAME, @PGroupid =B.GROUP_ID,@PLocationName= '', --AS LOCATION_NAME, 
                    @PRoleabbrid= B.ROLE_ABBR_ID ,@PUserTheme=F.THEME_NAME
			FROM    USERS A,   EMRUserRoleLocation B,   EMRRoleAbbreviationLkup C ,EMRThemesLkup F   
			WHERE   ((Upper(A.USER_LOGIN))) = ((Upper(@PLoginName))) AND A.USER_THEME = F.THEME_ID AND A.USER_LOGIN = B.USER_LOGIN  AND 
			((A.USER_PASS)) = ((@PPassWord)) AND B.ROLE_NAME  = C.ROLE_NAME   AND A.USER_THEME = F.THEME_ID AND A.USER_STATUS ='active' AND A.LOCKED_USER <> 1 
			ORDER BY C.ROLE_PRIORITY ASC
         IF @@ROWCOUNT >1
              Begin
					SELECT @PUserName= A.USER_LOGIN,@PUserFullName=A.USER_NAME,@PRoleName= B.ROLE_NAME, @PGroupid=  B.GROUP_ID,@PLocationName= '', --AS LOCATION_NAME,
					@PRoleabbrid=B.ROLE_ABBR_ID, @PUserTheme=F.THEME_NAME
					FROM    USERS A,   EMRUserRoleLocation B,   EMRRoleAbbreviationLkup C  , EMRThemesLkup F 
					WHERE   ((Upper(A.USER_LOGIN))) = ((Upper(@PLoginName))) AND A.USER_LOGIN = B.USER_LOGIN  AND 
					((A.USER_PASS)) = ((@PPassWord)) AND B.ROLE_NAME  = C.ROLE_NAME  AND A.USER_THEME = F.THEME_ID AND A.USER_STATUS ='active' AND A.LOCKED_USER <> 1 
					ORDER BY C.ROLE_PRIORITY ASC;
					SET @PSelectStat = ' SELECT  A.USER_LOGIN + A.USER_NAME + CAST(B.GROUP_ID AS VARCHAR) + '''' AS LOCATION_NAME + B.ROLE_ABBR_ID + B.ROLE_NAME + F.THEME_NAME as Fld'
					SET @PSelectStat = @PSelectStat + ' FROM    USERS A,   EMRUserRoleLocation B,   EMRRoleAbbreviationLkup C  , EMRThemesLkup F '
					SET @PSelectStat = @PSelectStat + ' WHERE   ((Upper(A.USER_LOGIN))) = ((Upper(PLoginName))) AND A.USER_LOGIN = B.USER_LOGIN  AND '
					SET @PSelectStat = @PSelectStat + ' ((A.USER_PASS)) = ((PPassWord)) AND B.ROLE_NAME  = C.ROLE_NAME  AND A.USER_THEME = F.THEME_ID AND A.USER_STATUS =''active'' AND A.LOCKED_USER <> 1 '
					SET @PSelectStat = @PSelectStat + ' ORDER BY C.ROLE_PRIORITY ASC'
					SET @PQueryFlag =1 

                End
            -----------------------------------------------
		End