SELECT ID  FROM PORTAL_USER WHERE ID IN  
(SELECT DESCENDANT_USER_ID FROM PORTAL_USER_HIERARCHY WHERE  
ANCESTOR_USER_ID IN  
(SELECT TO_USER_ID FROM PORTAL_USER_RELATIONSHIPS  
WHERE FROM_USER_ID IN  
(SELECT DESCENDANT_USER_ID FROM PORTAL_USER_HIERARCHY WHERE ANCESTOR_USER_ID IN  
  
(SELECT ID FROM PORTAL_USER WHERE [USER_NAME] = @USER_NAME)) --AND RELATION_TYPE_ID= 2  
)   
--AND   
--LEVEL_NMBR>0  
)  
  
) )--AND IS_OUTSTANDING = 0 changed because  sales user could not see saved requests defect id 968  
  

...SELECT  ID
FROM    PORTAL_USER pu
   JOIN PORTAL_USER_HIERARCHY puh
      ON pu.ID = puh.DESCENDANT_USER_ID
   JOIN PORTAL_USER_RELATIONSHIPS pur
      ON puh.ANCESTOR_USER_ID = pur.TO_USER_ID
...