Global stability analysis of open cavity flows in the acoustic limit