Do you know why it was returning more than one column, as you can see in my query I am only asking for one column "AGENTSURROGATECODE".
I dont know the database you are using. Can you try it in your database and see what it returns?
select AGENTSURROGATECODE from SETTLEMENT.AGENT_DETAILS where CYCLE = ?