The lead detective in charge of investigating Oscar Pistorius over the killing of Reeva Steenkamp has been stood down after revelations he is on attempted murder charges.