variable := SELECT * FROM admuser.projwbs WHERE proj_id = _proj_id AND rev_id=_rev_id AND wbs_id IN (
SELECT a1.wbs_id FROM temp2 a1 LEFT JOIN temp2 a2 ON a1.wbs_id=a2.parent_wbs_id
WHERE a2.wbs_id IS NULL AND a1.cnt IS NULL
DELETE variable
RETURNING variable