Случайно обнаружили:
IF (0 > 0) THEN
DELETE FROM temp_project_gtbl;
INSERT IGNORE INTO temp_project_gtbl(id)
SELECT id from project_tbl WHERE manager_id=p_person_id;
ELSE
IF (p_project_ids IS NOT NULL) THEN
fill_tmp_project_list(p_project_ids);
END IF;
END IF;