$connection = Yii::app()->db;
$command = $connection->createCommand("CALL sp_generate_payroll('$doc_date',$hrid,$clientid)");
$command->execute();
This statement will execute MySQL stored procedure by YII application. Tested successfully.