upadated the 'CASE' statement in some of the triggers