dbo.TSB_FGIPWODecisionForGroup

1     create   function dbo.TSB_FGIPWODecisionForGroup (@uid_personwantsorg varchar(38)) returns int as begin declare @erg int select @erg = 1  declare
2 @ObjectKeyOrdered varchar(138) declare @UID_PersonOrdered varchar(38) declare @SourceTable nvarchar(32) select top 1 @ObjectKeyOrdered = ObjectKeyOrdered
3, @UID_PersonOrdered = UID_PersonOrdered, @SourceTable = dbo.QBM_FCVObjectkeyToElement('TableName', ObjectKeyOrdered) from personwantsorg where uid_personwantsorg
4 = @uid_personWantsorg select @erg = case ( 4*sign(len(isnull(ra.UID_TSBAccountDef, '')))  + 2*sign(len(isnull(phr.UID_TSBAccountDef,'')))  + sign(len(isnull
5(pwoA.uid_personwantsorg, '')))  )  when 4 then 1 when 5 then 1 when 6 then 1 when 7 then 1 when 3 then 0 when 2 then 0 when 1 then 0  else -1 end from
6 personwantsorg pwo join TSBGroupToTSBAccountDef ga on pwo.ObjectKeyOrdered = @ObjectKeyOrdered and pwo.ObjectKeyOrdered = ga.ObjectKeyGroup and pwo.uid_personwantsorg
7 = @uid_personWantsorg and ga.BaseTableForPWO = @SourceTable  left outer join TSBAccountDefAndAccount ra on ga.UID_TSBAccountDef = ra.UID_TSBAccountDef
8 and ra.uid_person = @UID_PersonOrdered  left outer join PersonHasTSBAccountDef phr on ga.UID_TSBAccountDef =phr.UID_TSBAccountDef and phr.XOrigin > 0 
9and phr.XIsInEffect = 1 and phr.uid_person = @UID_PersonOrdered  left outer join personwantsorg pwoA on pwoA.uid_personordered = @UID_PersonOrdered and
10 pwoA.ObjectKeyOrdered = ga.ObjectKeyTSBAccountDef   and pwoA.OrderState in ('Assigned', 'OrderProduct', 'OrderProlongate', 'OrderUnsubscribe')    return
11 (@erg) end 
12