WHERE        (dbo.Positions.IsCurrent = 1) AND (dbo.Positions.Unit IN ('CCB', 'GM', 'SHA', 'CCB CCB', 'JCB')) AND (dbo.Positions.IsCurrent = 1) OR
                         (dbo.Positions.IsCurrent = 1) AND (dbo.Positions.Unit IN (N'PRODR', N'LIBR')) AND (dbo.Positions.Building_Position LIKE 'Sage Hal%') AND (dbo.Positions.IsCurrent = 1) OR
                         (dbo.Positions.IsCurrent = 1) AND (dbo.Positions.Supervisory_Org_Code = 'C-UJGSM') AND (dbo.Positions.IsCurrent = 1) OR
                         (dbo.Positions.IsCurrent = 1) AND (dbo.Positions.IsCurrent = 1) AND (dbo.Positions.KFS_Org = N'0100-0121')