Back to OIM Explorer

dbo.TSB_FGIPersonHasTSBAccountDef

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL25 lines
1CREATE FUNCTION dbo.TSB_FGIPersonHasTSBAccountDef(2  @P_IsInActive BIT,3  @P_IsTemporaryDeactivated BIT,4  @P_XMarkedForDeletion int,5  @PFDInheritAccountDef BIT,6  @PTDInheritAccountDef BIT,7  @PMDInheritAccountDef BIT,8  @P_IsSecurityIncident BIT,9  @PSIInheritAccountDef BIT10) RETURNS BIT11  WITH SCHEMABINDING12AS13BEGIN14  DECLARE @erg BIT = 015  DECLARE @QBM_BitPatternXMarkedForDel_Delay int = 0x0116  DECLARE @P_XMarkedForDeletion_bit1 int = @P_XMarkedForDeletion & @QBM_BitPatternXMarkedForDel_Delay17  IF(isnull(@p_IsInActive, 0) = 0 OR(@p_IsInActive = 1 AND @PFDInheritAccountDef = 1)) AND(isnull(@P_IsTemporaryDeactivated,18  0) = 0 OR(@P_IsTemporaryDeactivated = 1 AND @PTDInheritAccountDef = 1)) AND(@P_XMarkedForDeletion_bit1 = 0 OR(@P_XMarkedForDeletion_bit1 > 0 AND19  @PMDInheritAccountDef = 1)) AND(isnull(@P_IsSecurityIncident, 0) = 0 OR(@P_IsSecurityIncident = 1 AND @PSIInheritAccountDef = 1))20  BEGIN21    SELECT @erg = 122  END23  endLabel:24  RETURN(@erg)25END
Open raw exported source
SQL ยท Raw7 lines
1      create   function dbo.TSB_FGIPersonHasTSBAccountDef (  @P_IsInActive bit, @P_IsTemporaryDeactivated bit, @P_XMarkedForDeletion int, @PFDInheritAccountDef2 bit, @PTDInheritAccountDef bit, @PMDInheritAccountDef bit,  @P_IsSecurityIncident bit, @PSIInheritAccountDef bit ) returns bit with SCHEMABINDING as begin3 declare @erg bit = 0 declare @QBM_BitPatternXMarkedForDel_Delay int = 0x01  declare @P_XMarkedForDeletion_bit1 int = @P_XMarkedForDeletion & @QBM_BitPatternXMarkedForDel_Delay4 if (isnull(@p_IsInActive,0) = 0 or (@p_IsInActive = 1 and @PFDInheritAccountDef = 1)) and (isnull(@P_IsTemporaryDeactivated,0) = 0 or (@P_IsTemporaryDeactivated5 = 1 and @PTDInheritAccountDef = 1)) and (@P_XMarkedForDeletion_bit1 = 0 or ( @P_XMarkedForDeletion_bit1 > 0 and @PMDInheritAccountDef = 1)) and (isnull6(@P_IsSecurityIncident,0) = 0 or (@P_IsSecurityIncident = 1 and @PSIInheritAccountDef = 1)) begin select @erg = 1 end endLabel: return(@erg) end 7