Ralph is shot after you find out about Carl Brewer and discover that Frankie is missing.
If you're at the office before 5 pm on the day you expierence those two events, you'll see Ralph get shot.