DELETE FROM PS_SCRTY_SRCHGRP A
WHERE NOT EXISTS
(SELECT 'X' FROM PSPTSF_SRCCAT B
WHERE B.PTSF_ISGBLSRCH = 'Y'
AND B.PTSF_SRCCAT_NAME = A.PTSF_SRCHGRP_NAME)