TR_GLACCOUNT_DEL

        CREATE trigger dbo.TR_GLACCOUNT_DEL on dbo.GLACCOUNT
        with execute as owner
        for delete
        as
        begin
        set nocount on
        delete from dbo.PDACCOUNTLOOKUPCACHE where PDACCOUNTSYSTEMID in (select PDACCOUNTSYSTEMID from deleted)
        end