Back to OIM Explorer

dbo.CPL_FTCCSPersonsForPWO

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 656 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

SQL29 lines
1CREATE FUNCTION dbo.CPL_FTCCSPersonsForPWO(2  @UID_PersonWantsOrg varchar(38),3  @IsCrossPersonCheck BIT4) RETURNS @Persons TABLE(UID_Person varchar(38) collate database_default primary key(UID_Person)5)6AS7BEGIN8  IF @IsCrossPersonCheck = 19  BEGIN10    INSERT INTO @persons(UID_Person)11    SELECT12      DISTINCT me.UID_PersonAlsoMe13    FROM HelperPWOPersonHasObject pho14    JOIN QER_VPersonsAreMe me15      ON pho.UID_Person = me.UID_PersonOrigin16    WHERE17      pho.uid_personwantsorg = @uid_personwantsorg18  END19  ELSE20  BEGIN21    INSERT INTO @persons(UID_Person)22    SELECT23      DISTINCT pho.UID_Person24    FROM HelperPWOPersonHasObject pho25    WHERE26      pho.uid_personwantsorg = @uid_personwantsorg27  END28  RETURN29END
Open raw exported source
SQL ยท Raw6 lines
1create function dbo.CPL_FTCCSPersonsForPWO(@UID_PersonWantsOrg varchar(38) , @IsCrossPersonCheck bit  ) returns @Persons table (UID_Person varchar(38) 2collate database_default primary key (UID_Person) ) as begin if @IsCrossPersonCheck = 1 begin insert into @persons(UID_Person ) select distinct me.UID_PersonAlsoMe3 from HelperPWOPersonHasObject pho join QER_VPersonsAreMe me on pho.UID_Person = me.UID_PersonOrigin where pho.uid_personwantsorg = @uid_personwantsorg4 end else begin insert into @persons(UID_Person ) select distinct pho.UID_Person from HelperPWOPersonHasObject pho where pho.uid_personwantsorg = @uid_personwantsorg5 end return end 6