Value set using rank function

I have to create a VS using query

(select HG.GOAL_NAME,RANK () OVER (ORDER BY HG.CREATION_DATE) Goal_Seq , HRLT.RATING_DESCRIPTION Score
from HRA_EVALUATIONS HE,HRA_TMPL_DEFNS_TL HTDT,HRA_EVAL_ITEMS HEI, HRG_GOALS HG,hra_eval_ratings HER,HRT_RATING_LEVELS_TL HRLT
where HE.TEMPLATE_DEFN_ID = HTDT.TEMPLATE_DEFN_ID
AND HTDT.NAME = 'Scoring Template'
AND HE.WORKER_ID = :{PARAMETER.P_Person_id}
AND REFERENCE_ITEM_ID = HG.GOAL_ID
AND HEI.EVALUATION_ID = HE.EVALUATION_ID
AND HER.EVALUATION_ID = HE.EVALUATION_ID
AND HER.ROLE_TYPE_CODE = 'WORKER'
AND REFERENCE_TYPE = 'ITEM'