dbo.QER_FTPwoValidDateRanges

1create function dbo.QER_FTPwoValidDateRanges(@UID_PersonOrdered varchar(38)  , @UID_ITShopOrgPR varchar(38)  ) returns @erg table(FromDatetime datetime
2 , UntilDatetime datetime ) as begin declare @heute datetime = getutcdate() declare @ObjectKeyAnPR varchar(138) declare @QER_BitPatternInheritInfo int 
3= dbo.QER_FGIBitPatternInheritInfo('|Direct|', 0) declare @ist QBM_YDateTimePair declare @GapDefinition int = 0 select @GapDefinition = dbo.QBM_FCVStringToInt
4(dbo.QBM_FGIConfigparmValue('QER\ITShop\GapBehavior\GapDefinition'), 0) select top 1 @ObjectKeyAnPR = bho.ObjectKey from BaseTreeHasObject bho where bho.UID_Org
5 = @UID_ITShopOrgPR and bho.InheritInfo = @QER_BitPatternInheritInfo insert into @ist (FromDate , ToDate) select case when isnull(pwo.ValidFrom, '1899-12-30'
6) < @heute then @heute else pwo.ValidFrom end , dbo.QBM_FCVDatetimeToDatetimeEve(isnull(pwo.ValidUntil, '2200-01-01')) from PersonWantsOrg pwo join BaseTreeHasObject
7 bho on pwo.UID_Org = bho.UID_Org and bho.InheritInfo = @QER_BitPatternInheritInfo where  bho.ObjectKey = @ObjectKeyAnPR and pwo.UID_PersonOrdered = @UID_PersonOrdered
8        and (pwo.Orderstate in ('Assigned', 'Granted', 'New', 'OrderProduct', 'OrderProlongate', 'OrderUnsubscribe', 'Waiting') and @GapDefinition = 0 
9 or pwo.OrderState in ('Assigned', 'Granted', 'OrderProlongate', 'OrderUnsubscribe', 'Waiting') and @GapDefinition = 1  or pwo.OrderState in ('Assigned'
10, 'OrderProlongate', 'OrderUnsubscribe' ) and @GapDefinition = 2  ) insert into @erg(FromDatetime, UntilDatetime) select g.GapStart, g.GapEnd from dbo.QBM_FTDateTimeGaps
11(@ist) g endLabel: return end 
12