TR_PDACCOUNTSEGMENTMAPPING_IUD

        CREATE trigger dbo.TR_PDACCOUNTSEGMENTMAPPING_IUD on dbo.PDACCOUNTSEGMENTMAPPING
        with execute as owner
        for insert, update, delete
        as
        begin
        set nocount on
        if (select count(*) from deleted) = 0   --insert

          delete PDACCOUNTLOOKUPCACHE
          from dbo.PDACCOUNTLOOKUPCACHE inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTLOOKUPCACHE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
          inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSYSTEM.ID = PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID
          inner join inserted on PDACCOUNTSTRUCTURE.ID = inserted.PDACCOUNTSTRUCTUREID
          where PDACCOUNTSYSTEM.DEFAULTGLACCOUNTID is not null
          and PDACCOUNTLOOKUPCACHE.ERRORNUMBER != 0
        else
          delete PDACCOUNTLOOKUPCACHE
          from dbo.PDACCOUNTLOOKUPCACHE inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTLOOKUPCACHE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
          inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSYSTEM.ID = PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID
          inner join deleted on PDACCOUNTSTRUCTURE.ID = deleted.PDACCOUNTSTRUCTUREID

        end