SELECT 
TB1.COMPANY 
,TB1.EMPLID         
,TB1.STATE 
,TB1.LOCALITY 
,TB1.TAX_CLASS 
,TB1.TXGRS_YTD 
,TB1.NLGRS_YTD 
,TB1.TAX_YTD 
,T1.BOX 
,T1.AMOUNT_TYPE 
FROM  PS_TAX_BALANCE TB1, PS_TAXFORM_TAX T1, 
      PS_W2_COMPANY C1 
WHERE C1.W2_REPORTING_CO = 'HEU' 
  AND C1.CALENDAR_YEAR   = 2006 
  AND T1.TAXFORM_ID      = 'W' 
  AND T1.EFFDT           =  '01-JAN-2006' 
  AND T1.TAX_CLASS IN ('H','D','E','F','G','J','Q','T','Z','C','K','V','L','M','N','W') 
  AND TB1.EMPLID = '1031026' 
  AND TB1.COMPANY         = C1.COMPANY 
  AND TB1.BALANCE_ID      = 'CY' 
  AND TB1.BALANCE_YEAR    = 2006 
  AND T1.TAX_CLASS       = TB1.TAX_CLASS 
  AND ( (T1.JURISDICTION_TYPE = 'F' AND TB1.STATE  LIKE '$U%') 
    OR  (  (T1.JURISDICTION_TYPE = 'S' 
            AND TB1.STATE <> '$U' 
            AND TB1.LOCALITY  = ' ') 
      AND  (TB1.STATE = T1.STATE OR T1.STATE = ' ') ) 
    OR  (  (T1.JURISDICTION_TYPE = 'L' 
            AND TB1.STATE <> '$U' 
            AND TB1.LOCALITY <> ' ') 
      AND  (TB1.STATE = T1.STATE OR T1.STATE = ' ') 
      AND  (TB1.LOCALITY = T1.LOCALITY or T1.LOCALITY = ' ') ) ) 
  AND TB1.BALANCE_PERIOD = 
      (SELECT MAX(BALANCE_PERIOD) 
       FROM   PS_TAX_BALANCE 
       WHERE  EMPLID        = TB1.emplid 
         AND  COMPANY       = TB1.company 
         AND  BALANCE_YEAR = TB1.balance_year 
         AND  BALANCE_ID = TB1.balance_id 
         AND  STATE         = TB1.state 
         AND  LOCALITY     = ' ' 
         AND  TAX_CLASS     = TB1.tax_class) 
  AND (TB1.TXGRS_YTD <> 0  OR  TB1.TAX_YTD <> 0) 
 ORDER BY TB1.EMPLID, TB1.STATE, TB1.LOCALITY, TB1.TAX_CLASS,TB1.COMPANY