General Ledger Delete Unused Groups Query

Preview with select query:

Select * from gltacgrp g
 where not exists
    ( select * from gltacct a where a.gl_group = g.group_id)
  and not exists
    ( select * from gltacgrp g2 where g2.parent_group_id = g.group_id)

DELETE from gltacgrp g
 where not exists
    ( select * from gltacct a where a.gl_group = g.group_id)
  and not exists
    ( select * from gltacgrp g2 where g2.parent_group_id = g.group_id)