dbo.DPR_FTProjectionRootRunning

1create function dbo.DPR_FTProjectionRootRunning ()      returns table as return (  select x.ObjectKeyRoot as ObjectKeyRoot , x.BaseTableName as BaseTableName
2 from ( select ci.ObjectKeyRoot, t.TableName as BaseTableName, t.UID_DialogTable , isnull(si.LastStart , '1899-12-30') as LastStart from DPRRootObjConnectionInfo
3 ci join DPRProjectionStartInfo si with (nolock) on ci.UID_DPRRootObjConnectionInfo = si.UID_DPRRootObjConnectionInfo join DialogTable t with (readpast
4) on ci.ObjectKeyRoot like '<Key><T>' + t.TableName + '</T>%' where (exists ( select top 1 1 from DPRProjectionConfigStep cs where cs.UID_DPRProjectionConfig
5 = si.UID_DPRProjectionConfig and cs.UID_LeftDPRSystemConnection = ci.UID_DPRSystemConnection ) or exists ( select top 1 1 from DPRProjectionConfigStep
6 cs where cs.UID_DPRProjectionConfig = si.UID_DPRProjectionConfig and cs.UID_RightDPRSystemConnection = ci.UID_DPRSystemConnection ) ) ) as x   left outer
7 join DialogConfigParm cp on LEFT(x.UID_DialogTable, 3) = LEFT(cp.UID_ConfigParm, 3) and cp.FullPath like 'TargetSystem\%\MaxFullsyncDuration' where dateadd
8(mi , case when cp.UID_ConfigParm is null then 720  when dbo.QBM_FCVStringToInt(right(dbo.QBM_FGIConfigparmValue(cp.FullPath),6), 720 ) > 10080 then 10080
9 else dbo.QBM_FCVStringToInt(right(dbo.QBM_FGIConfigparmValue(cp.FullPath),6), 720 ) end , isnull(x.LastStart , '1899-12-30') ) > getutcdate() ) 
10