General Ledger Delete GLTFSDEF Records for Missing Groups

delete from gltfsdef fs
 WHERE CMDNO IN (1,3) AND PARAM1_TYPE=3 AND NOT EXISTS ( SELECT GROUP_ID FROM  gltacgrp  g WHERE g.group_id=fs.param1)