select security promotion view 1