---

select
    id,
    name,
    code
from ourpension.sharer_statuses
where service_type = :service_type
order by name




#set ( $l = $db.find($get_account_states) )

{
    'list': [
        #if ($l)
            #foreach ( $t in $l )
            {
                'id': '$t.id',
                'name': '$t.name',
                'code': '$t.code'
            }#if($foreach.hasNext),#end
            #end
        #end
    ]
}