Question:

I know it's possible to return the USERID in a query builder condition using :USERID and setting the condition to use the value as a literal. Is there a similar way to return the SECCODEID?

Answer:

:userid == the ID of the Current User.

When you refer to SeccodeID, what ID do you want to return?
The User's Security Team?
If so, use :ownerid


Now, if you are referring to the User's Default Owner as setup on the Options, use a Literal and enter the following:
(SELECT OPTIONVALUE FROM USEROPTIONS WHERE CATEGORY = 'General' AND NAME = 'InsertSecCodeID' AND USERID = :userid)