BEGIN

DECLARE @OK AS INT 
DECLARE @CODPOSITION_REQUESTER AS INT 
DECLARE @CODAREA_REQUESTER AS INT 
DECLARE @CODPOSITION AS INT 
DECLARE @CODAREA AS INT 

SET @CODPOSITION_REQUESTER = 1436 --Coordenadora designer - Renata Carolina Martins Figueira 
SET @CODAREA_REQUESTER = 2821--Easy to learn

SET @OK = 0	
SET @CODPOSITION = (SELECT CODPARENTPOSITION FROM WFPOSITION WHERE CODPOSITION = @CODPOSITION_REQUESTER)

--SE NAO TEM POSICAO PAI 
IF(@CODPOSITION IS NULL) 
BEGIN 
--PEGA A MESMA POSICAO DO REQUISITANTE 
SET @CODPOSITION = @CODPOSITION_REQUESTER 
--TENHO QUE PULAR PRA PORXIMA AREA 
SET @CODAREA = (SELECT CODPARENTAREA FROM WFAREA WHERE CODAREA = @CODAREA_REQUESTER) 
--DECLARE @RET AS VARCHAR(255) 
--SET @RET = CONVERT(VARCHAR, @CODPOSITION) + '/' + CONVERT(VARCHAR, @CODAREA) 
--RAISERROR (@RET,16,-1)

END 
--SE TEM 
ELSE 
BEGIN 
SET @CODAREA = @CODAREA_REQUESTER

END

WHILE(@OK=0 AND @CODAREA IS NOT NULL) 
BEGIN

IF(SELECT COUNT(*) FROM WFPOSITION_AREA WHERE CODAREA = @CODAREA AND CODPOSITION = @CODPOSITION)>0 
BEGIN 
SET @OK = 1 
END 
ELSE 
BEGIN 
SET @CODAREA = (SELECT CODPARENTAREA FROM WFAREA WHERE CODAREA = @CODAREA) 
END 
END

SELECT * fROM WFVWPOSITION_AREA WHERE CODPOSITION = @CODPOSITION AND CODAREA = @CODAREA 
SELECT * fROM WFVWUSER_POSITION WHERE CODPOSITION = @CODPOSITION AND CODAREA = @CODAREA	
END