create function dbo.fun_finalpid(@orgid varchar(50))
returns varchar(500)
as
begin
declare @orgpid varchar(50)
declare @reOrgid varchar(50)
declare @orgfl varchar(50)
declare @i int
set @i=1
while @i<6
begin
set @orgpid=(select orgpid from org where orgid=@orgid)
set @orgfl=(select orgfl from org where orgid=@orgpid)
if(@orgfl='UM')
begin
set @reOrgid=(select orgpid from org where orgid=@orgid)
return @reOrgid
end
set @orgid=(select orgpid from org where orgid=@orgid)
set @i=@i+1
end
return @reOrgid
end