dbo.QER_FTEntitlementSourceWho

1CREATE FUNCTION dbo.QER_FTEntitlementSourceWho(2  @ObjectKeyToInspect varchar(138)3) RETURNS @erg TABLE(UID_Person varchar(38) collate database_default4)5AS6BEGIN7  IF @ObjectKeyToInspect LIKE '<Key><T>ADSAccount</T>%'8  BEGIN9    INSERT INTO @erg(uid_person)10    SELECT11    /*distinct */12    xx.UID_Person13    FROM dbo.GEN_FTEOE3FC1F72D986050366C6F0(@ObjectKeyToInspect) AS xx14    GOTO EndLabel15  END16  -- ADSAccount17  IF @ObjectKeyToInspect LIKE '<Key><T>ADSAccountInADSGroup</T>%'18  BEGIN19    INSERT INTO @erg(uid_person)20    SELECT21    /*distinct */22    xx.UID_Person23    FROM dbo.GEN_FTEOCBE1F5EFEA131E8729A6FF(@ObjectKeyToInspect) AS xx24    GOTO EndLabel25  END26  -- ADSAccountInADSGroup27  IF @ObjectKeyToInspect LIKE '<Key><T>ADSContact</T>%'28  BEGIN29    INSERT INTO @erg(uid_person)30    SELECT31    /*distinct */32    xx.UID_Person33    FROM dbo.GEN_FTEO232AA5350399AF5B5E7FC8(@ObjectKeyToInspect) AS xx34    GOTO EndLabel35  END36  -- ADSContact37  IF @ObjectKeyToInspect LIKE '<Key><T>ADSContactInADSGroup</T>%'38  BEGIN39    INSERT INTO @erg(uid_person)40    SELECT41    /*distinct */42    xx.UID_Person43    FROM dbo.GEN_FTEOC7B20A6BD971728008EA89(@ObjectKeyToInspect) AS xx44    GOTO EndLabel45  END46  -- ADSContactInADSGroup47  IF @ObjectKeyToInspect LIKE '<Key><T>ADSContainer</T>%'48  BEGIN49    INSERT INTO @erg(uid_person)50    SELECT51    /*distinct */52    xx.UID_Person53    FROM dbo.GEN_FTEO9EF81AB6EE40C7C1070D2B(@ObjectKeyToInspect) AS xx54    GOTO EndLabel55  END56  -- ADSContainer57  IF @ObjectKeyToInspect LIKE '<Key><T>ADSDomain</T>%'58  BEGIN59    INSERT INTO @erg(uid_person)60    SELECT61    /*distinct */62    xx.UID_Person63    FROM dbo.GEN_FTEO23E9A1A9473A3635194231(@ObjectKeyToInspect) AS xx64    GOTO EndLabel65  END66  -- ADSDomain67  IF @ObjectKeyToInspect LIKE '<Key><T>ADSGroup</T>%'68  BEGIN69    INSERT INTO @erg(uid_person)70    SELECT71    /*distinct */72    xx.UID_Person73    FROM dbo.GEN_FTEO6FE29BD24EE8070A0F58FF(@ObjectKeyToInspect) AS xx74    GOTO EndLabel75  END76  -- ADSGroup77  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasADSGroup</T>%'78  BEGIN79    INSERT INTO @erg(uid_person)80    SELECT81    /*distinct */82    xx.UID_Person83    FROM dbo.GEN_FTEO1A5AB0AC4F306F2C2F87EF(@ObjectKeyToInspect) AS xx84    GOTO EndLabel85  END86  -- DepartmentHasADSGroup87  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasADSGroup</T>%'88  BEGIN89    INSERT INTO @erg(uid_person)90    SELECT91    /*distinct */92    xx.UID_Person93    FROM dbo.GEN_FTEO006D3653F3A90269D7477C(@ObjectKeyToInspect) AS xx94    GOTO EndLabel95  END96  -- ITShopOrgHasADSGroup97  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasADSGroup</T>%'98  BEGIN99    INSERT INTO @erg(uid_person)100    SELECT101    /*distinct */102    xx.UID_Person103    FROM dbo.GEN_FTEO78008E5B70C578F9A41FB2(@ObjectKeyToInspect) AS xx104    GOTO EndLabel105  END106  -- ITShopSrcHasADSGroup107  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasADSGroup</T>%'108  BEGIN109    INSERT INTO @erg(uid_person)110    SELECT111    /*distinct */112    xx.UID_Person113    FROM dbo.GEN_FTEO571DE06F0F845F2770450A(@ObjectKeyToInspect) AS xx114    GOTO EndLabel115  END116  -- LocalityHasADSGroup117  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasADSGroup</T>%'118  BEGIN119    INSERT INTO @erg(uid_person)120    SELECT121    /*distinct */122    xx.UID_Person123    FROM dbo.GEN_FTEO9D98EE26C0BD92E6C753ED(@ObjectKeyToInspect) AS xx124    GOTO EndLabel125  END126  -- OrgHasADSGroup127  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasADSGroup</T>%'128  BEGIN129    INSERT INTO @erg(uid_person)130    SELECT131    /*distinct */132    xx.UID_Person133    FROM dbo.GEN_FTEO6127AC664CEAB79755A263(@ObjectKeyToInspect) AS xx134    GOTO EndLabel135  END136  -- ProfitCenterHasADSGroup137  IF @ObjectKeyToInspect LIKE '<Key><T>PersonInNonCompliance</T>%'138  BEGIN139    INSERT INTO @erg(uid_person)140    SELECT141    /*distinct */142    xx.UID_Person143    FROM dbo.GEN_FTEO02CBE2B071CB6020466EA6(@ObjectKeyToInspect) AS xx144    GOTO EndLabel145  END146  -- PersonInNonCompliance147  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasLDAPGroup</T>%'148  BEGIN149    INSERT INTO @erg(uid_person)150    SELECT151    /*distinct */152    xx.UID_Person153    FROM dbo.GEN_FTEO0EDC8574A3FA2D64F9D50A(@ObjectKeyToInspect) AS xx154    GOTO EndLabel155  END156  -- DepartmentHasLDAPGroup157  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasLDAPGroup</T>%'158  BEGIN159    INSERT INTO @erg(uid_person)160    SELECT161    /*distinct */162    xx.UID_Person163    FROM dbo.GEN_FTEOAF1EC18D18BF11B4872359(@ObjectKeyToInspect) AS xx164    GOTO EndLabel165  END166  -- ITShopOrgHasLDAPGroup167  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasLDAPGroup</T>%'168  BEGIN169    INSERT INTO @erg(uid_person)170    SELECT171    /*distinct */172    xx.UID_Person173    FROM dbo.GEN_FTEO3D188781B44D49B2F0B86D(@ObjectKeyToInspect) AS xx174    GOTO EndLabel175  END176  -- ITShopSrcHasLDAPGroup177  IF @ObjectKeyToInspect LIKE '<Key><T>LDAPAccount</T>%'178  BEGIN179    INSERT INTO @erg(uid_person)180    SELECT181    /*distinct */182    xx.UID_Person183    FROM dbo.GEN_FTEO8EA948B41AC2A60335AE0F(@ObjectKeyToInspect) AS xx184    GOTO EndLabel185  END186  -- LDAPAccount187  IF @ObjectKeyToInspect LIKE '<Key><T>LDAPAccountInLDAPGroup</T>%'188  BEGIN189    INSERT INTO @erg(uid_person)190    SELECT191    /*distinct */192    xx.UID_Person193    FROM dbo.GEN_FTEO88C3252E4822EEB5E56129(@ObjectKeyToInspect) AS xx194    GOTO EndLabel195  END196  -- LDAPAccountInLDAPGroup197  IF @ObjectKeyToInspect LIKE '<Key><T>LDAPContainer</T>%'198  BEGIN199    INSERT INTO @erg(uid_person)200    SELECT201    /*distinct */202    xx.UID_Person203    FROM dbo.GEN_FTEO3077299134008999AC844A(@ObjectKeyToInspect) AS xx204    GOTO EndLabel205  END206  -- LDAPContainer207  IF @ObjectKeyToInspect LIKE '<Key><T>LDAPGroup</T>%'208  BEGIN209    INSERT INTO @erg(uid_person)210    SELECT211    /*distinct */212    xx.UID_Person213    FROM dbo.GEN_FTEO441C2F873660C363A87E18(@ObjectKeyToInspect) AS xx214    GOTO EndLabel215  END216  -- LDAPGroup217  IF @ObjectKeyToInspect LIKE '<Key><T>LDPDomain</T>%'218  BEGIN219    INSERT INTO @erg(uid_person)220    SELECT221    /*distinct */222    xx.UID_Person223    FROM dbo.GEN_FTEOADB5D482192FECE896DB8D(@ObjectKeyToInspect) AS xx224    GOTO EndLabel225  END226  -- LDPDomain227  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasLDAPGroup</T>%'228  BEGIN229    INSERT INTO @erg(uid_person)230    SELECT231    /*distinct */232    xx.UID_Person233    FROM dbo.GEN_FTEO56BF6085851555680F56E2(@ObjectKeyToInspect) AS xx234    GOTO EndLabel235  END236  -- LocalityHasLDAPGroup237  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasLDAPGroup</T>%'238  BEGIN239    INSERT INTO @erg(uid_person)240    SELECT241    /*distinct */242    xx.UID_Person243    FROM dbo.GEN_FTEOD6B7883AF33FD1CE427C46(@ObjectKeyToInspect) AS xx244    GOTO EndLabel245  END246  -- OrgHasLDAPGroup247  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasLDAPGroup</T>%'248  BEGIN249    INSERT INTO @erg(uid_person)250    SELECT251    /*distinct */252    xx.UID_Person253    FROM dbo.GEN_FTEOB2D535C0B0425DCAA6927A(@ObjectKeyToInspect) AS xx254    GOTO EndLabel255  END256  -- ProfitCenterHasLDAPGroup257  IF @ObjectKeyToInspect LIKE '<Key><T>AccProduct</T>%'258  BEGIN259    INSERT INTO @erg(uid_person)260    SELECT261    /*distinct */262    xx.UID_Person263    FROM dbo.GEN_FTEOD74410BBDA5C1BE51102F6(@ObjectKeyToInspect) AS xx264    GOTO EndLabel265  END266  -- AccProduct267  IF @ObjectKeyToInspect LIKE '<Key><T>AERole</T>%'268  BEGIN269    INSERT INTO @erg(uid_person)270    SELECT271    /*distinct */272    xx.UID_Person273    FROM dbo.GEN_FTEOC4405A4105AF7A5C86BF0B(@ObjectKeyToInspect) AS xx274    GOTO EndLabel275  END276  -- AERole277  IF @ObjectKeyToInspect LIKE '<Key><T>AERoleHasQERResource</T>%'278  BEGIN279    INSERT INTO @erg(uid_person)280    SELECT281    /*distinct */282    xx.UID_Person283    FROM dbo.GEN_FTEOB5C679685E9F8BFB80D9AF(@ObjectKeyToInspect) AS xx284    GOTO EndLabel285  END286  -- AERoleHasQERResource287  IF @ObjectKeyToInspect LIKE '<Key><T>ComplianceRule</T>%'288  BEGIN289    INSERT INTO @erg(uid_person)290    SELECT291    /*distinct */292    xx.UID_Person293    FROM dbo.GEN_FTEOB965962346D1874BF023AB(@ObjectKeyToInspect) AS xx294    GOTO EndLabel295  END296  -- ComplianceRule297  IF @ObjectKeyToInspect LIKE '<Key><T>Department</T>%'298  BEGIN299    INSERT INTO @erg(uid_person)300    SELECT301    /*distinct */302    xx.UID_Person303    FROM dbo.GEN_FTEO5A5E2E14035E407A3503D1(@ObjectKeyToInspect) AS xx304    GOTO EndLabel305  END306  -- Department307  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERAssign</T>%'308  BEGIN309    INSERT INTO @erg(uid_person)310    SELECT311    /*distinct */312    xx.UID_Person313    FROM dbo.GEN_FTEO7850C0E557233D1B42CCBF(@ObjectKeyToInspect) AS xx314    GOTO EndLabel315  END316  -- DepartmentHasQERAssign317  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERResource</T>%'318  BEGIN319    INSERT INTO @erg(uid_person)320    SELECT321    /*distinct */322    xx.UID_Person323    FROM dbo.GEN_FTEOF8181E29775D04AE6D5526(@ObjectKeyToInspect) AS xx324    GOTO EndLabel325  END326  -- DepartmentHasQERResource327  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERReuse</T>%'328  BEGIN329    INSERT INTO @erg(uid_person)330    SELECT331    /*distinct */332    xx.UID_Person333    FROM dbo.GEN_FTEO28A2459499E91085A71994(@ObjectKeyToInspect) AS xx334    GOTO EndLabel335  END336  -- DepartmentHasQERReuse337  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERReuseUS</T>%'338  BEGIN339    INSERT INTO @erg(uid_person)340    SELECT341    /*distinct */342    xx.UID_Person343    FROM dbo.GEN_FTEODC415EB845AEA9700D4736(@ObjectKeyToInspect) AS xx344    GOTO EndLabel345  END346  -- DepartmentHasQERReuseUS347  IF @ObjectKeyToInspect LIKE '<Key><T>ESet</T>%'348  BEGIN349    INSERT INTO @erg(uid_person)350    SELECT351    /*distinct */352    xx.UID_Person353    FROM dbo.GEN_FTEO1F6AADC53DA5B3F53E4D4D(@ObjectKeyToInspect) AS xx354    GOTO EndLabel355  END356  -- ESet357  IF @ObjectKeyToInspect LIKE '<Key><T>ESetHasEntitlement</T>%'358  BEGIN359    INSERT INTO @erg(uid_person)360    SELECT361    /*distinct */362    xx.UID_Person363    FROM dbo.GEN_FTEO3108D0E5786C74FD0F6143(@ObjectKeyToInspect) AS xx364    GOTO EndLabel365  END366  -- ESetHasEntitlement367  IF @ObjectKeyToInspect LIKE '<Key><T>HelperHeadOrg</T>%'368  BEGIN369    INSERT INTO @erg(uid_person)370    SELECT371    /*distinct */372    xx.UID_Person373    FROM dbo.GEN_FTEO51124460D781C27F2EB0B7(@ObjectKeyToInspect) AS xx374    GOTO EndLabel375  END376  -- HelperHeadOrg377  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrg</T>%'378  BEGIN379    INSERT INTO @erg(uid_person)380    SELECT381    /*distinct */382    xx.UID_Person383    FROM dbo.GEN_FTEO0B25503331E8414BA325BE(@ObjectKeyToInspect) AS xx384    GOTO EndLabel385  END386  -- ITShopOrg387  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasPWODecisionMethod</T>%'388  BEGIN389    INSERT INTO @erg(uid_person)390    SELECT391    /*distinct */392    xx.UID_Person393    FROM dbo.GEN_FTEOF3648634FE1AE4CC04D6E3(@ObjectKeyToInspect) AS xx394    GOTO EndLabel395  END396  -- ITShopOrgHasPWODecisionMethod397  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERAssign</T>%'398  BEGIN399    INSERT INTO @erg(uid_person)400    SELECT401    /*distinct */402    xx.UID_Person403    FROM dbo.GEN_FTEO124603C4ECA4923BA02CD1(@ObjectKeyToInspect) AS xx404    GOTO EndLabel405  END406  -- ITShopOrgHasQERAssign407  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERResource</T>%'408  BEGIN409    INSERT INTO @erg(uid_person)410    SELECT411    /*distinct */412    xx.UID_Person413    FROM dbo.GEN_FTEO77A9FDA5C1EA828F236BDD(@ObjectKeyToInspect) AS xx414    GOTO EndLabel415  END416  -- ITShopOrgHasQERResource417  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERReuse</T>%'418  BEGIN419    INSERT INTO @erg(uid_person)420    SELECT421    /*distinct */422    xx.UID_Person423    FROM dbo.GEN_FTEO7C273B59BCD5A19218AD6E(@ObjectKeyToInspect) AS xx424    GOTO EndLabel425  END426  -- ITShopOrgHasQERReuse427  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERReuseUS</T>%'428  BEGIN429    INSERT INTO @erg(uid_person)430    SELECT431    /*distinct */432    xx.UID_Person433    FROM dbo.GEN_FTEO600EF8000C21B93AD22340(@ObjectKeyToInspect) AS xx434    GOTO EndLabel435  END436  -- ITShopOrgHasQERReuseUS437  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasPWODecisionMethod</T>%'438  BEGIN439    INSERT INTO @erg(uid_person)440    SELECT441    /*distinct */442    xx.UID_Person443    FROM dbo.GEN_FTEOF8EB48BC7A2AB71231077A(@ObjectKeyToInspect) AS xx444    GOTO EndLabel445  END446  -- ITShopSrcHasPWODecisionMethod447  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERAssign</T>%'448  BEGIN449    INSERT INTO @erg(uid_person)450    SELECT451    /*distinct */452    xx.UID_Person453    FROM dbo.GEN_FTEO4FAD48B2C16719AA6AA10A(@ObjectKeyToInspect) AS xx454    GOTO EndLabel455  END456  -- ITShopSrcHasQERAssign457  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERResource</T>%'458  BEGIN459    INSERT INTO @erg(uid_person)460    SELECT461    /*distinct */462    xx.UID_Person463    FROM dbo.GEN_FTEO2C7526BB07DB9C7586664C(@ObjectKeyToInspect) AS xx464    GOTO EndLabel465  END466  -- ITShopSrcHasQERResource467  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERReuse</T>%'468  BEGIN469    INSERT INTO @erg(uid_person)470    SELECT471    /*distinct */472    xx.UID_Person473    FROM dbo.GEN_FTEODE642CEE7EF80F321AEF2B(@ObjectKeyToInspect) AS xx474    GOTO EndLabel475  END476  -- ITShopSrcHasQERReuse477  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERReuseUS</T>%'478  BEGIN479    INSERT INTO @erg(uid_person)480    SELECT481    /*distinct */482    xx.UID_Person483    FROM dbo.GEN_FTEOA707EB18AFD3AEB659DC74(@ObjectKeyToInspect) AS xx484    GOTO EndLabel485  END486  -- ITShopSrcHasQERReuseUS487  IF @ObjectKeyToInspect LIKE '<Key><T>Locality</T>%'488  BEGIN489    INSERT INTO @erg(uid_person)490    SELECT491    /*distinct */492    xx.UID_Person493    FROM dbo.GEN_FTEO283DABF5CB0C2E27D0F558(@ObjectKeyToInspect) AS xx494    GOTO EndLabel495  END496  -- Locality497  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERAssign</T>%'498  BEGIN499    INSERT INTO @erg(uid_person)500    SELECT501    /*distinct */502    xx.UID_Person503    FROM dbo.GEN_FTEO39066D8F7C9AD7CEAEF3FF(@ObjectKeyToInspect) AS xx504    GOTO EndLabel505  END506  -- LocalityHasQERAssign507  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERResource</T>%'508  BEGIN509    INSERT INTO @erg(uid_person)510    SELECT511    /*distinct */512    xx.UID_Person513    FROM dbo.GEN_FTEO876EEF41AC6D6820E6BF7A(@ObjectKeyToInspect) AS xx514    GOTO EndLabel515  END516  -- LocalityHasQERResource517  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERReuse</T>%'518  BEGIN519    INSERT INTO @erg(uid_person)520    SELECT521    /*distinct */522    xx.UID_Person523    FROM dbo.GEN_FTEO367CE1B2CFF414B5FB884A(@ObjectKeyToInspect) AS xx524    GOTO EndLabel525  END526  -- LocalityHasQERReuse527  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERReuseUS</T>%'528  BEGIN529    INSERT INTO @erg(uid_person)530    SELECT531    /*distinct */532    xx.UID_Person533    FROM dbo.GEN_FTEO561124721D666224302112(@ObjectKeyToInspect) AS xx534    GOTO EndLabel535  END536  -- LocalityHasQERReuseUS537  IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasESet</T>%'538  BEGIN539    INSERT INTO @erg(uid_person)540    SELECT541    /*distinct */542    xx.UID_Person543    FROM dbo.GEN_FTEO43DA50DFD7474F509FE625(@ObjectKeyToInspect) AS xx544    GOTO EndLabel545  END546  -- PersonHasESet547  IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERAssign</T>%'548  BEGIN549    INSERT INTO @erg(uid_person)550    SELECT551    /*distinct */552    xx.UID_Person553    FROM dbo.GEN_FTEO2449A21EFB122D2AF3B920(@ObjectKeyToInspect) AS xx554    GOTO EndLabel555  END556  -- PersonHasQERAssign557  IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERResource</T>%'558  BEGIN559    INSERT INTO @erg(uid_person)560    SELECT561    /*distinct */562    xx.UID_Person563    FROM dbo.GEN_FTEO2DFFC3597F23CBA73DEBA2(@ObjectKeyToInspect) AS xx564    GOTO EndLabel565  END566  -- PersonHasQERResource567  IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERReuse</T>%'568  BEGIN569    INSERT INTO @erg(uid_person)570    SELECT571    /*distinct */572    xx.UID_Person573    FROM dbo.GEN_FTEO4F410D16844712C63A98BA(@ObjectKeyToInspect) AS xx574    GOTO EndLabel575  END576  -- PersonHasQERReuse577  IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERReuseUS</T>%'578  BEGIN579    INSERT INTO @erg(uid_person)580    SELECT581    /*distinct */582    xx.UID_Person583    FROM dbo.GEN_FTEOFCDDA80E733A80CFE09BC5(@ObjectKeyToInspect) AS xx584    GOTO EndLabel585  END586  -- PersonHasQERReuseUS587  IF @ObjectKeyToInspect LIKE '<Key><T>PersonInAERole</T>%'588  BEGIN589    INSERT INTO @erg(uid_person)590    SELECT591    /*distinct */592    xx.UID_Person593    FROM dbo.GEN_FTEO9AF242348875AFC053A649(@ObjectKeyToInspect) AS xx594    GOTO EndLabel595  END596  -- PersonInAERole597  IF @ObjectKeyToInspect LIKE '<Key><T>PersonInDepartment</T>%'598  BEGIN599    INSERT INTO @erg(uid_person)600    SELECT601    /*distinct */602    xx.UID_Person603    FROM dbo.GEN_FTEO04F18550BAA5EF552107EF(@ObjectKeyToInspect) AS xx604    GOTO EndLabel605  END606  -- PersonInDepartment607  IF @ObjectKeyToInspect LIKE '<Key><T>PersonInITShopOrg</T>%'608  BEGIN609    INSERT INTO @erg(uid_person)610    SELECT611    /*distinct */612    xx.UID_Person613    FROM dbo.GEN_FTEOD2110A8D430CBD7D961961(@ObjectKeyToInspect) AS xx614    GOTO EndLabel615  END616  -- PersonInITShopOrg617  IF @ObjectKeyToInspect LIKE '<Key><T>PersonInLocality</T>%'618  BEGIN619    INSERT INTO @erg(uid_person)620    SELECT621    /*distinct */622    xx.UID_Person623    FROM dbo.GEN_FTEOB37287BA6CF952714E9E05(@ObjectKeyToInspect) AS xx624    GOTO EndLabel625  END626  -- PersonInLocality627  IF @ObjectKeyToInspect LIKE '<Key><T>PersonInProfitCenter</T>%'628  BEGIN629    INSERT INTO @erg(uid_person)630    SELECT631    /*distinct */632    xx.UID_Person633    FROM dbo.GEN_FTEO8864B48D6F511D0508888B(@ObjectKeyToInspect) AS xx634    GOTO EndLabel635  END636  -- PersonInProfitCenter637  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenter</T>%'638  BEGIN639    INSERT INTO @erg(uid_person)640    SELECT641    /*distinct */642    xx.UID_Person643    FROM dbo.GEN_FTEOD1E38A3A879DDF3DAB838E(@ObjectKeyToInspect) AS xx644    GOTO EndLabel645  END646  -- ProfitCenter647  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERAssign</T>%'648  BEGIN649    INSERT INTO @erg(uid_person)650    SELECT651    /*distinct */652    xx.UID_Person653    FROM dbo.GEN_FTEO1AD7DE86A579FA2409914E(@ObjectKeyToInspect) AS xx654    GOTO EndLabel655  END656  -- ProfitCenterHasQERAssign657  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERResource</T>%'658  BEGIN659    INSERT INTO @erg(uid_person)660    SELECT661    /*distinct */662    xx.UID_Person663    FROM dbo.GEN_FTEO25BCD2079C53589A9285E1(@ObjectKeyToInspect) AS xx664    GOTO EndLabel665  END666  -- ProfitCenterHasQERResource667  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERReuse</T>%'668  BEGIN669    INSERT INTO @erg(uid_person)670    SELECT671    /*distinct */672    xx.UID_Person673    FROM dbo.GEN_FTEOEC43185C598C8AD42BBAC7(@ObjectKeyToInspect) AS xx674    GOTO EndLabel675  END676  -- ProfitCenterHasQERReuse677  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERReuseUS</T>%'678  BEGIN679    INSERT INTO @erg(uid_person)680    SELECT681    /*distinct */682    xx.UID_Person683    FROM dbo.GEN_FTEOB6B06C1E337B666C531D2A(@ObjectKeyToInspect) AS xx684    GOTO EndLabel685  END686  -- ProfitCenterHasQERReuseUS687  IF @ObjectKeyToInspect LIKE '<Key><T>QERAssign</T>%'688  BEGIN689    INSERT INTO @erg(uid_person)690    SELECT691    /*distinct */692    xx.UID_Person693    FROM dbo.GEN_FTEOBEBB8A4A554D3F83C9F986(@ObjectKeyToInspect) AS xx694    GOTO EndLabel695  END696  -- QERAssign697  IF @ObjectKeyToInspect LIKE '<Key><T>QERResource</T>%'698  BEGIN699    INSERT INTO @erg(uid_person)700    SELECT701    /*distinct */702    xx.UID_Person703    FROM dbo.GEN_FTEOF378BB872D5FCEAED0E90F(@ObjectKeyToInspect) AS xx704    GOTO EndLabel705  END706  -- QERResource707  IF @ObjectKeyToInspect LIKE '<Key><T>QERReuse</T>%'708  BEGIN709    INSERT INTO @erg(uid_person)710    SELECT711    /*distinct */712    xx.UID_Person713    FROM dbo.GEN_FTEO4E5921D551EC885BEFB26E(@ObjectKeyToInspect) AS xx714    GOTO EndLabel715  END716  -- QERReuse717  IF @ObjectKeyToInspect LIKE '<Key><T>QERReuseUS</T>%'718  BEGIN719    INSERT INTO @erg(uid_person)720    SELECT721    /*distinct */722    xx.UID_Person723    FROM dbo.GEN_FTEO29472A7EC8BF68D730175A(@ObjectKeyToInspect) AS xx724    GOTO EndLabel725  END726  -- QERReuseUS727  IF @ObjectKeyToInspect LIKE '<Key><T>Org</T>%'728  BEGIN729    INSERT INTO @erg(uid_person)730    SELECT731    /*distinct */732    xx.UID_Person733    FROM dbo.GEN_FTEOD8B0B6D2BA27064DB4C878(@ObjectKeyToInspect) AS xx734    GOTO EndLabel735  END736  -- Org737  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERAssign</T>%'738  BEGIN739    INSERT INTO @erg(uid_person)740    SELECT741    /*distinct */742    xx.UID_Person743    FROM dbo.GEN_FTEO9EBFD3FDDDC9D840459B1C(@ObjectKeyToInspect) AS xx744    GOTO EndLabel745  END746  -- OrgHasQERAssign747  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERResource</T>%'748  BEGIN749    INSERT INTO @erg(uid_person)750    SELECT751    /*distinct */752    xx.UID_Person753    FROM dbo.GEN_FTEOCA638CE8E06208A9F58B78(@ObjectKeyToInspect) AS xx754    GOTO EndLabel755  END756  -- OrgHasQERResource757  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERReuse</T>%'758  BEGIN759    INSERT INTO @erg(uid_person)760    SELECT761    /*distinct */762    xx.UID_Person763    FROM dbo.GEN_FTEO0EAA3325F4B764158A37C9(@ObjectKeyToInspect) AS xx764    GOTO EndLabel765  END766  -- OrgHasQERReuse767  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERReuseUS</T>%'768  BEGIN769    INSERT INTO @erg(uid_person)770    SELECT771    /*distinct */772    xx.UID_Person773    FROM dbo.GEN_FTEO706B2DAD7C59B720D3AB83(@ObjectKeyToInspect) AS xx774    GOTO EndLabel775  END776  -- OrgHasQERReuseUS777  IF @ObjectKeyToInspect LIKE '<Key><T>PersonInOrg</T>%'778  BEGIN779    INSERT INTO @erg(uid_person)780    SELECT781    /*distinct */782    xx.UID_Person783    FROM dbo.GEN_FTEO41BDBF3DEDBD7A3EDBE1DF(@ObjectKeyToInspect) AS xx784    GOTO EndLabel785  END786  -- PersonInOrg787  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasESet</T>%'788  BEGIN789    INSERT INTO @erg(uid_person)790    SELECT791    /*distinct */792    xx.UID_Person793    FROM dbo.GEN_FTEO0C997F262B960A18247092(@ObjectKeyToInspect) AS xx794    GOTO EndLabel795  END796  -- DepartmentHasESet797  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasESet</T>%'798  BEGIN799    INSERT INTO @erg(uid_person)800    SELECT801    /*distinct */802    xx.UID_Person803    FROM dbo.GEN_FTEO813E7E2CD1CCFDDA1FB4B0(@ObjectKeyToInspect) AS xx804    GOTO EndLabel805  END806  -- ITShopOrgHasESet807  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasESet</T>%'808  BEGIN809    INSERT INTO @erg(uid_person)810    SELECT811    /*distinct */812    xx.UID_Person813    FROM dbo.GEN_FTEODBCCF0ACCB4C6C4A2652F1(@ObjectKeyToInspect) AS xx814    GOTO EndLabel815  END816  -- ITShopSrcHasESet817  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasESet</T>%'818  BEGIN819    INSERT INTO @erg(uid_person)820    SELECT821    /*distinct */822    xx.UID_Person823    FROM dbo.GEN_FTEO26A4E144352362B3E4284C(@ObjectKeyToInspect) AS xx824    GOTO EndLabel825  END826  -- LocalityHasESet827  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasESet</T>%'828  BEGIN829    INSERT INTO @erg(uid_person)830    SELECT831    /*distinct */832    xx.UID_Person833    FROM dbo.GEN_FTEO97D908781BC9D443D0401D(@ObjectKeyToInspect) AS xx834    GOTO EndLabel835  END836  -- OrgHasESet837  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasESet</T>%'838  BEGIN839    INSERT INTO @erg(uid_person)840    SELECT841    /*distinct */842    xx.UID_Person843    FROM dbo.GEN_FTEO68C1DBD023EDBEBC483394(@ObjectKeyToInspect) AS xx844    GOTO EndLabel845  END846  -- ProfitCenterHasESet847  IF @ObjectKeyToInspect LIKE '<Key><T>AERoleHasRPSReport</T>%'848  BEGIN849    INSERT INTO @erg(uid_person)850    SELECT851    /*distinct */852    xx.UID_Person853    FROM dbo.GEN_FTEO10971C9480677C7F862216(@ObjectKeyToInspect) AS xx854    GOTO EndLabel855  END856  -- AERoleHasRPSReport857  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasRPSReport</T>%'858  BEGIN859    INSERT INTO @erg(uid_person)860    SELECT861    /*distinct */862    xx.UID_Person863    FROM dbo.GEN_FTEO1D1CA7D5FD62681C041DEC(@ObjectKeyToInspect) AS xx864    GOTO EndLabel865  END866  -- DepartmentHasRPSReport867  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasRPSReport</T>%'868  BEGIN869    INSERT INTO @erg(uid_person)870    SELECT871    /*distinct */872    xx.UID_Person873    FROM dbo.GEN_FTEOF3591ACC43EAD381AF1626(@ObjectKeyToInspect) AS xx874    GOTO EndLabel875  END876  -- ITShopOrgHasRPSReport877  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasRPSReport</T>%'878  BEGIN879    INSERT INTO @erg(uid_person)880    SELECT881    /*distinct */882    xx.UID_Person883    FROM dbo.GEN_FTEOA3730A0231D3DD7638F7BC(@ObjectKeyToInspect) AS xx884    GOTO EndLabel885  END886  -- ITShopSrcHasRPSReport887  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasRPSReport</T>%'888  BEGIN889    INSERT INTO @erg(uid_person)890    SELECT891    /*distinct */892    xx.UID_Person893    FROM dbo.GEN_FTEO9E905677168B2599FECD5F(@ObjectKeyToInspect) AS xx894    GOTO EndLabel895  END896  -- LocalityHasRPSReport897  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasRPSReport</T>%'898  BEGIN899    INSERT INTO @erg(uid_person)900    SELECT901    /*distinct */902    xx.UID_Person903    FROM dbo.GEN_FTEO6224CD38BD1B4497851790(@ObjectKeyToInspect) AS xx904    GOTO EndLabel905  END906  -- OrgHasRPSReport907  IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasRPSReport</T>%'908  BEGIN909    INSERT INTO @erg(uid_person)910    SELECT911    /*distinct */912    xx.UID_Person913    FROM dbo.GEN_FTEO9D4FD2292EFC748015E780(@ObjectKeyToInspect) AS xx914    GOTO EndLabel915  END916  -- PersonHasRPSReport917  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasRPSReport</T>%'918  BEGIN919    INSERT INTO @erg(uid_person)920    SELECT921    /*distinct */922    xx.UID_Person923    FROM dbo.GEN_FTEO8E13F4963076C7F5D04DB8(@ObjectKeyToInspect) AS xx924    GOTO EndLabel925  END926  -- ProfitCenterHasRPSReport927  IF @ObjectKeyToInspect LIKE '<Key><T>RPSReport</T>%'928  BEGIN929    INSERT INTO @erg(uid_person)930    SELECT931    /*distinct */932    xx.UID_Person933    FROM dbo.GEN_FTEO8EDF537F72D2FFD396F085(@ObjectKeyToInspect) AS xx934    GOTO EndLabel935  END936  -- RPSReport937  IF @ObjectKeyToInspect LIKE '<Key><T>AERoleHasTSBAccountDef</T>%'938  BEGIN939    INSERT INTO @erg(uid_person)940    SELECT941    /*distinct */942    xx.UID_Person943    FROM dbo.GEN_FTEO7AD62C2E28328C7A2F99F7(@ObjectKeyToInspect) AS xx944    GOTO EndLabel945  END946  -- AERoleHasTSBAccountDef947  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasTSBAccountDef</T>%'948  BEGIN949    INSERT INTO @erg(uid_person)950    SELECT951    /*distinct */952    xx.UID_Person953    FROM dbo.GEN_FTEOA8C482BC8C48F3C962FF50(@ObjectKeyToInspect) AS xx954    GOTO EndLabel955  END956  -- DepartmentHasTSBAccountDef957  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB</T>%'958  BEGIN959    INSERT INTO @erg(uid_person)960    SELECT961    /*distinct */962    xx.UID_Person963    FROM dbo.GEN_FTEO2CE4612D8CC0CDCDA47E09(@ObjectKeyToInspect) AS xx964    GOTO EndLabel965  END966  -- DepartmentHasUNSGroupB967  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB1</T>%'968  BEGIN969    INSERT INTO @erg(uid_person)970    SELECT971    /*distinct */972    xx.UID_Person973    FROM dbo.GEN_FTEOA9BD5D5E2DDEA5B88787B8(@ObjectKeyToInspect) AS xx974    GOTO EndLabel975  END976  -- DepartmentHasUNSGroupB1977  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB2</T>%'978  BEGIN979    INSERT INTO @erg(uid_person)980    SELECT981    /*distinct */982    xx.UID_Person983    FROM dbo.GEN_FTEO63E550B307F1843BBAEA41(@ObjectKeyToInspect) AS xx984    GOTO EndLabel985  END986  -- DepartmentHasUNSGroupB2987  IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB3</T>%'988  BEGIN989    INSERT INTO @erg(uid_person)990    SELECT991    /*distinct */992    xx.UID_Person993    FROM dbo.GEN_FTEOBF13787D687DDE946FAC9E(@ObjectKeyToInspect) AS xx994    GOTO EndLabel995  END996  -- DepartmentHasUNSGroupB3997  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasTSBAccountDef</T>%'998  BEGIN999    INSERT INTO @erg(uid_person)1000    SELECT1001    /*distinct */1002    xx.UID_Person1003    FROM dbo.GEN_FTEOB80009FA08F681D63B4108(@ObjectKeyToInspect) AS xx1004    GOTO EndLabel1005  END1006  -- ITShopOrgHasTSBAccountDef1007  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB</T>%'1008  BEGIN1009    INSERT INTO @erg(uid_person)1010    SELECT1011    /*distinct */1012    xx.UID_Person1013    FROM dbo.GEN_FTEO4E10ADF9DCFEF7C9C58342(@ObjectKeyToInspect) AS xx1014    GOTO EndLabel1015  END1016  -- ITShopOrgHasUNSGroupB1017  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB1</T>%'1018  BEGIN1019    INSERT INTO @erg(uid_person)1020    SELECT1021    /*distinct */1022    xx.UID_Person1023    FROM dbo.GEN_FTEO32A5C78A846D6205D96590(@ObjectKeyToInspect) AS xx1024    GOTO EndLabel1025  END1026  -- ITShopOrgHasUNSGroupB11027  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB2</T>%'1028  BEGIN1029    INSERT INTO @erg(uid_person)1030    SELECT1031    /*distinct */1032    xx.UID_Person1033    FROM dbo.GEN_FTEOAD799FB98908DDB42033D6(@ObjectKeyToInspect) AS xx1034    GOTO EndLabel1035  END1036  -- ITShopOrgHasUNSGroupB21037  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB3</T>%'1038  BEGIN1039    INSERT INTO @erg(uid_person)1040    SELECT1041    /*distinct */1042    xx.UID_Person1043    FROM dbo.GEN_FTEOB3B2560AB2854AC430D072(@ObjectKeyToInspect) AS xx1044    GOTO EndLabel1045  END1046  -- ITShopOrgHasUNSGroupB31047  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasTSBAccountDef</T>%'1048  BEGIN1049    INSERT INTO @erg(uid_person)1050    SELECT1051    /*distinct */1052    xx.UID_Person1053    FROM dbo.GEN_FTEOA951733A12082916D3851A(@ObjectKeyToInspect) AS xx1054    GOTO EndLabel1055  END1056  -- ITShopSrcHasTSBAccountDef1057  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB</T>%'1058  BEGIN1059    INSERT INTO @erg(uid_person)1060    SELECT1061    /*distinct */1062    xx.UID_Person1063    FROM dbo.GEN_FTEO4F21B63459864B663447DB(@ObjectKeyToInspect) AS xx1064    GOTO EndLabel1065  END1066  -- ITShopSrcHasUNSGroupB1067  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB1</T>%'1068  BEGIN1069    INSERT INTO @erg(uid_person)1070    SELECT1071    /*distinct */1072    xx.UID_Person1073    FROM dbo.GEN_FTEO65CF709953376CFE851623(@ObjectKeyToInspect) AS xx1074    GOTO EndLabel1075  END1076  -- ITShopSrcHasUNSGroupB11077  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB2</T>%'1078  BEGIN1079    INSERT INTO @erg(uid_person)1080    SELECT1081    /*distinct */1082    xx.UID_Person1083    FROM dbo.GEN_FTEOA2CD631FB056F00F8EB771(@ObjectKeyToInspect) AS xx1084    GOTO EndLabel1085  END1086  -- ITShopSrcHasUNSGroupB21087  IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB3</T>%'1088  BEGIN1089    INSERT INTO @erg(uid_person)1090    SELECT1091    /*distinct */1092    xx.UID_Person1093    FROM dbo.GEN_FTEO3B9C6D580006D4DD813B7E(@ObjectKeyToInspect) AS xx1094    GOTO EndLabel1095  END1096  -- ITShopSrcHasUNSGroupB31097  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasTSBAccountDef</T>%'1098  BEGIN1099    INSERT INTO @erg(uid_person)1100    SELECT1101    /*distinct */1102    xx.UID_Person1103    FROM dbo.GEN_FTEOD0D66D215B55F3F96C96AD(@ObjectKeyToInspect) AS xx1104    GOTO EndLabel1105  END1106  -- LocalityHasTSBAccountDef1107  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB</T>%'1108  BEGIN1109    INSERT INTO @erg(uid_person)1110    SELECT1111    /*distinct */1112    xx.UID_Person1113    FROM dbo.GEN_FTEOFD1EFA425BAA6B7E15ADE3(@ObjectKeyToInspect) AS xx1114    GOTO EndLabel1115  END1116  -- LocalityHasUNSGroupB1117  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB1</T>%'1118  BEGIN1119    INSERT INTO @erg(uid_person)1120    SELECT1121    /*distinct */1122    xx.UID_Person1123    FROM dbo.GEN_FTEO5D16B76C939BD16B7F25EC(@ObjectKeyToInspect) AS xx1124    GOTO EndLabel1125  END1126  -- LocalityHasUNSGroupB11127  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB2</T>%'1128  BEGIN1129    INSERT INTO @erg(uid_person)1130    SELECT1131    /*distinct */1132    xx.UID_Person1133    FROM dbo.GEN_FTEO61B64082003B832769B7DF(@ObjectKeyToInspect) AS xx1134    GOTO EndLabel1135  END1136  -- LocalityHasUNSGroupB21137  IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB3</T>%'1138  BEGIN1139    INSERT INTO @erg(uid_person)1140    SELECT1141    /*distinct */1142    xx.UID_Person1143    FROM dbo.GEN_FTEO90AA6311D0390A1E4D5F33(@ObjectKeyToInspect) AS xx1144    GOTO EndLabel1145  END1146  -- LocalityHasUNSGroupB31147  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasTSBAccountDef</T>%'1148  BEGIN1149    INSERT INTO @erg(uid_person)1150    SELECT1151    /*distinct */1152    xx.UID_Person1153    FROM dbo.GEN_FTEOF79E5B68763946AD37AC2D(@ObjectKeyToInspect) AS xx1154    GOTO EndLabel1155  END1156  -- OrgHasTSBAccountDef1157  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB</T>%'1158  BEGIN1159    INSERT INTO @erg(uid_person)1160    SELECT1161    /*distinct */1162    xx.UID_Person1163    FROM dbo.GEN_FTEO964FB112702DE4BFCBC649(@ObjectKeyToInspect) AS xx1164    GOTO EndLabel1165  END1166  -- OrgHasUNSGroupB1167  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB1</T>%'1168  BEGIN1169    INSERT INTO @erg(uid_person)1170    SELECT1171    /*distinct */1172    xx.UID_Person1173    FROM dbo.GEN_FTEO21EE4A2BA66BA2714303E5(@ObjectKeyToInspect) AS xx1174    GOTO EndLabel1175  END1176  -- OrgHasUNSGroupB11177  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB2</T>%'1178  BEGIN1179    INSERT INTO @erg(uid_person)1180    SELECT1181    /*distinct */1182    xx.UID_Person1183    FROM dbo.GEN_FTEOEE436F5AE4FD21173A888F(@ObjectKeyToInspect) AS xx1184    GOTO EndLabel1185  END1186  -- OrgHasUNSGroupB21187  IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB3</T>%'1188  BEGIN1189    INSERT INTO @erg(uid_person)1190    SELECT1191    /*distinct */1192    xx.UID_Person1193    FROM dbo.GEN_FTEODB55B8F6DCCF7F77DBFE9B(@ObjectKeyToInspect) AS xx1194    GOTO EndLabel1195  END1196  -- OrgHasUNSGroupB31197  IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasTSBAccountDef</T>%'1198  BEGIN1199    INSERT INTO @erg(uid_person)1200    SELECT1201    /*distinct */1202    xx.UID_Person1203    FROM dbo.GEN_FTEO25F2BE28B359A147002484(@ObjectKeyToInspect) AS xx1204    GOTO EndLabel1205  END1206  -- PersonHasTSBAccountDef1207  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasTSBAccountDef</T>%'1208  BEGIN1209    INSERT INTO @erg(uid_person)1210    SELECT1211    /*distinct */1212    xx.UID_Person1213    FROM dbo.GEN_FTEOF8865C9F0579C831B69628(@ObjectKeyToInspect) AS xx1214    GOTO EndLabel1215  END1216  -- ProfitCenterHasTSBAccountDef1217  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB</T>%'1218  BEGIN1219    INSERT INTO @erg(uid_person)1220    SELECT1221    /*distinct */1222    xx.UID_Person1223    FROM dbo.GEN_FTEO837FD4744287294377BA88(@ObjectKeyToInspect) AS xx1224    GOTO EndLabel1225  END1226  -- ProfitCenterHasUNSGroupB1227  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB1</T>%'1228  BEGIN1229    INSERT INTO @erg(uid_person)1230    SELECT1231    /*distinct */1232    xx.UID_Person1233    FROM dbo.GEN_FTEO35B790B0C5AAABB0EBD859(@ObjectKeyToInspect) AS xx1234    GOTO EndLabel1235  END1236  -- ProfitCenterHasUNSGroupB11237  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB2</T>%'1238  BEGIN1239    INSERT INTO @erg(uid_person)1240    SELECT1241    /*distinct */1242    xx.UID_Person1243    FROM dbo.GEN_FTEO8B96783B24FC6E0786844D(@ObjectKeyToInspect) AS xx1244    GOTO EndLabel1245  END1246  -- ProfitCenterHasUNSGroupB21247  IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB3</T>%'1248  BEGIN1249    INSERT INTO @erg(uid_person)1250    SELECT1251    /*distinct */1252    xx.UID_Person1253    FROM dbo.GEN_FTEOCCEC6FAAAADDAE4E64A778(@ObjectKeyToInspect) AS xx1254    GOTO EndLabel1255  END1256  -- ProfitCenterHasUNSGroupB31257  IF @ObjectKeyToInspect LIKE '<Key><T>TSBAccountDef</T>%'1258  BEGIN1259    INSERT INTO @erg(uid_person)1260    SELECT1261    /*distinct */1262    xx.UID_Person1263    FROM dbo.GEN_FTEO921D2C20632DB6993D8D70(@ObjectKeyToInspect) AS xx1264    GOTO EndLabel1265  END1266  -- TSBAccountDef1267  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountB</T>%'1268  BEGIN1269    INSERT INTO @erg(uid_person)1270    SELECT1271    /*distinct */1272    xx.UID_Person1273    FROM dbo.GEN_FTEOA46777E2E24BAD58D2DC9B(@ObjectKeyToInspect) AS xx1274    GOTO EndLabel1275  END1276  -- UNSAccountB1277  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB</T>%'1278  BEGIN1279    INSERT INTO @erg(uid_person)1280    SELECT1281    /*distinct */1282    xx.UID_Person1283    FROM dbo.GEN_FTEO79FCA5E06289E312186F5F(@ObjectKeyToInspect) AS xx1284    GOTO EndLabel1285  END1286  -- UNSAccountBHasUNSGroupB1287  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB1</T>%'1288  BEGIN1289    INSERT INTO @erg(uid_person)1290    SELECT1291    /*distinct */1292    xx.UID_Person1293    FROM dbo.GEN_FTEO4A7CF4B45C2D7BC9EDAD37(@ObjectKeyToInspect) AS xx1294    GOTO EndLabel1295  END1296  -- UNSAccountBHasUNSGroupB11297  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB2</T>%'1298  BEGIN1299    INSERT INTO @erg(uid_person)1300    SELECT1301    /*distinct */1302    xx.UID_Person1303    FROM dbo.GEN_FTEOE03F4413CB822BD15BB87C(@ObjectKeyToInspect) AS xx1304    GOTO EndLabel1305  END1306  -- UNSAccountBHasUNSGroupB21307  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB3</T>%'1308  BEGIN1309    INSERT INTO @erg(uid_person)1310    SELECT1311    /*distinct */1312    xx.UID_Person1313    FROM dbo.GEN_FTEOA7A83C03AC63E92F4E255A(@ObjectKeyToInspect) AS xx1314    GOTO EndLabel1315  END1316  -- UNSAccountBHasUNSGroupB31317  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB</T>%'1318  BEGIN1319    INSERT INTO @erg(uid_person)1320    SELECT1321    /*distinct */1322    xx.UID_Person1323    FROM dbo.GEN_FTEODFBC578DBC3E90294FC921(@ObjectKeyToInspect) AS xx1324    GOTO EndLabel1325  END1326  -- UNSAccountBInUNSGroupB1327  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB1</T>%'1328  BEGIN1329    INSERT INTO @erg(uid_person)1330    SELECT1331    /*distinct */1332    xx.UID_Person1333    FROM dbo.GEN_FTEO4CA65D90167B38E40B176D(@ObjectKeyToInspect) AS xx1334    GOTO EndLabel1335  END1336  -- UNSAccountBInUNSGroupB11337  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB2</T>%'1338  BEGIN1339    INSERT INTO @erg(uid_person)1340    SELECT1341    /*distinct */1342    xx.UID_Person1343    FROM dbo.GEN_FTEOCC97ED88B89CA73E2DA389(@ObjectKeyToInspect) AS xx1344    GOTO EndLabel1345  END1346  -- UNSAccountBInUNSGroupB21347  IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB3</T>%'1348  BEGIN1349    INSERT INTO @erg(uid_person)1350    SELECT1351    /*distinct */1352    xx.UID_Person1353    FROM dbo.GEN_FTEO747E5F4E3A4061542A3456(@ObjectKeyToInspect) AS xx1354    GOTO EndLabel1355  END1356  -- UNSAccountBInUNSGroupB31357  IF @ObjectKeyToInspect LIKE '<Key><T>UNSContainerB</T>%'1358  BEGIN1359    INSERT INTO @erg(uid_person)1360    SELECT1361    /*distinct */1362    xx.UID_Person1363    FROM dbo.GEN_FTEO6FA34C069DA6C1F7D48FBE(@ObjectKeyToInspect) AS xx1364    GOTO EndLabel1365  END1366  -- UNSContainerB1367  IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB</T>%'1368  BEGIN1369    INSERT INTO @erg(uid_person)1370    SELECT1371    /*distinct */1372    xx.UID_Person1373    FROM dbo.GEN_FTEOB7D443E409F1129BFD9922(@ObjectKeyToInspect) AS xx1374    GOTO EndLabel1375  END1376  -- UNSGroupB1377  IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB1</T>%'1378  BEGIN1379    INSERT INTO @erg(uid_person)1380    SELECT1381    /*distinct */1382    xx.UID_Person1383    FROM dbo.GEN_FTEOACC993FDAF5792E1B59AE0(@ObjectKeyToInspect) AS xx1384    GOTO EndLabel1385  END1386  -- UNSGroupB11387  IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB2</T>%'1388  BEGIN1389    INSERT INTO @erg(uid_person)1390    SELECT1391    /*distinct */1392    xx.UID_Person1393    FROM dbo.GEN_FTEOD48DD3E8DD9E49B431EC66(@ObjectKeyToInspect) AS xx1394    GOTO EndLabel1395  END1396  -- UNSGroupB21397  IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB3</T>%'1398  BEGIN1399    INSERT INTO @erg(uid_person)1400    SELECT1401    /*distinct */1402    xx.UID_Person1403    FROM dbo.GEN_FTEO9226A461259BE698109D7C(@ObjectKeyToInspect) AS xx1404    GOTO EndLabel1405  END1406  -- UNSGroupB31407  IF @ObjectKeyToInspect LIKE '<Key><T>UNSRootB</T>%'1408  BEGIN1409    INSERT INTO @erg(uid_person)1410    SELECT1411    /*distinct */1412    xx.UID_Person1413    FROM dbo.GEN_FTEOD0423232E940C76F51DB95(@ObjectKeyToInspect) AS xx1414    GOTO EndLabel1415  END1416  -- UNSRootB1417  --insert into @erg(uid_person)1418  --select distinct UID_Person1419  -- from @work1420  endLabel:1421  RETURN1422END