ALTER PROCEDURE [dbo].[Widget_PreApprovalForms_Search]
    @FormStatusId INT = NULL ,
    @CreatedBy INT = NULL ,
    @FormEmployeeId INT = NULL ,
    @ApproverId INT = NULL ,
    @RegionId VARCHAR(50) = NULL
AS
    DECLARE @localFormStatusId INT
    SET @localFormStatusId = @FormStatusId
    DECLARE @localCreatedBy INT
    SET @localCreatedBy = @CreatedBy
    DECLARE @localFormEmployeeId INT
    SET @localFormEmployeeId = @FormEmployeeId
    DECLARE @localApproverId INT
    SET @localApproverId = @ApproverId
    DECLARE @localRegionId VARCHAR(50)
    SET @localRegionId = @RegionId


    SELECT DISTINCT
            DT.* ,
            ISNULL(NULLIF(CAST(DT.FormRegionCode AS VARCHAR(50)), ''),
                   Region.short_name) AS Region
    FROM    ( SELECT    FBD.FormId ,
                        FBD.AlternateId ,
                        FBD.VerificationValue ,
                        FBD.TypeId AS FormTypeId ,
                        FBD.FormTypeDescription AS Description ,
                        FBD.DashboardIcon ,
                        FBD.CreatedByName AS CreatedByUser ,
                        CAST(NULL AS VARCHAR(20)) AS NonEmployeeName ,
                        CAST(NULL AS VARCHAR(20)) AS ForUser ,
                        FBD.EmployeeOrUserName AS ForDisplayName ,
                        FBD.EmployeeIndex AS ForEmployeeIndex ,
                        FBD.FormStatusId ,
                        FBD.FormStatus AS FormStatusDescription ,
                        FBD.CreatedDate ,
                        FBD.ClosedDate ,
                        DATEDIFF(d, FBD.CreatedDate,
                                 ISNULL(FBD.ClosedDate, GETDATE())) AS DaysOpen ,
                        CPA.CurrentApproverName AS PendingApproverName ,
                        CPA.CurrentApproverId AS PendingApproverUserId ,
                        CAST(NULL AS VARCHAR(20)) AS PendingApproverUserIdExpanded ,
                        ISNULL(ForEmployeeRegion.region_id,
                               CreatedEmployeeRegion.region_id) AS RegionId ,
                        FBD.RegionCode AS FormRegionCode ,
                        CAST(NULL AS VARCHAR(20)) AS RoutePlanExpanded
              FROM      FormBaseData_View FBD
                        INNER JOIN dbo.CurrentAndPriorApprovers_View AS CPA ON FBD.FormId = CPA.FormId
                        LEFT OUTER JOIN WalshGroup_staff_data_syn AS ForEmployeeRegion ON FBD.EmployeeIndex = ForEmployeeRegion.empl_index
                        LEFT OUTER JOIN WalshGroup_staff_data_syn AS CreatedEmployeeRegion ON FBD.CreatedById = CreatedEmployeeRegion.empl_index
                        LEFT OUTER JOIN WalshGroup_group_membership_syn GM ON CPA.CurrentApproverId = GM.group_id
              WHERE     ( ( FBD.FormStatusId = @localFormStatusId
                            OR ( FBD.FormStatusId = 3
                                 AND @localFormStatusId IS NOT NULL
                               )
                          )
                          OR @localFormStatusId IS NULL
                        )
                        AND ( FBD.CreatedById = @localCreatedBy
                              OR @localCreatedBy IS NULL
                            )
                        AND ( FBD.EmployeeIndex = @localFormEmployeeId
                              OR @localFormEmployeeId IS NULL
                            )
                        AND ( @localApproverId IS NULL
                              OR ( @localApproverId IS NOT NULL
                                   AND ( ( @localFormStatusId = 1
                                           AND ( CPA.CurrentApproverId = @localApproverId
                                                 OR GM.login_id = @localApproverId
                                               )
                                         )
                                         OR @localFormStatusId IS NULL
                                         AND FBD.FormId IN (
                                         SELECT FormID
                                         FROM   dbo.RoutePlan
                                         WHERE  Deleted = 0
                                                AND UserId = @localApproverId
                                                AND RoutePlanStatusID > 1 )
                                       )
                                 )
                            )
    --((@localFormStatusId = 1 AND CPA.CurrentApproverId = @ApproverId)
    --           OR
    --          (@localFormStatusId IS NULL AND @ApproverId IN (SELECT 6))
    --          ) OR

    --        )
            ) AS DT
            LEFT OUTER JOIN WalshGroup_regions_syn AS Region ON DT.RegionId = Region.region_id
    WHERE   ( DT.RegionId = @localRegionId
              OR @localRegionId IS NULL
            )