Back to OIM Explorer

dbo.CPL_FTComplianceSubRulePerson

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 771 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL23 lines
1CREATE FUNCTION dbo.CPL_FTComplianceSubRulePerson(2  @UID_ComplianceRule varchar(38)3) RETURNS TABLE4  WITH schemabinding5AS6RETURN(7SELECT csp.UID_Person8FROM dbo.ComplianceSubRulePerson csp9JOIN dbo.ComplianceRule r10  ON csp.UID_ComplianceRule = r.UID_ComplianceRule11WHERE12  r.UID_ComplianceRule = @UID_ComplianceRule AND r.IsPersonStoreInverted = 0 AND r.IsInActive = 0 AND r.IsWorkingCopy = 013UNION all14SELECT p.UID_Person15FROM dbo.Person p CROSS16JOIN dbo.ComplianceRule r17LEFT18OUTER19JOIN dbo.ComplianceSubRulePerson csp20  ON p.UID_Person = csp.UID_Person AND csp.UID_ComplianceRule = r.UID_ComplianceRule21WHERE22  csp.UID_Person IS NULL AND r.UID_ComplianceRule = @UID_ComplianceRule AND r.IsPersonStoreInverted = 1 AND r.IsInActive = 0 AND r.IsWorkingCopy23= 0)
Open raw exported source
SQL ยท Raw6 lines
1create function dbo.CPL_FTComplianceSubRulePerson (@UID_ComplianceRule varchar(38) ) returns table with schemabinding as return (  select csp.UID_Person2 from dbo.ComplianceSubRulePerson csp join dbo.ComplianceRule r on csp.UID_ComplianceRule = r.UID_ComplianceRule where r.UID_ComplianceRule = @UID_ComplianceRule3 and r.IsPersonStoreInverted = 0  and r.IsInActive = 0 and r.IsWorkingCopy = 0  union all  select p.UID_Person from dbo.Person p cross join dbo.ComplianceRule4 r left outer join dbo.ComplianceSubRulePerson csp on p.UID_Person = csp.UID_Person and csp.UID_ComplianceRule = r.UID_ComplianceRule where csp.UID_Person5 is null and r.UID_ComplianceRule = @UID_ComplianceRule and r.IsPersonStoreInverted = 1  and r.IsInActive = 0 and r.IsWorkingCopy = 0 ) 6