Below query gives me response OF candidate when answer type is text but not when is LOV

Summary:

Below query gives me response submitted by candidates when answer type is text but not answer is list of values and i need to show the value candidate has selected.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24C

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT hprv.ANSWER_TEXT FROMper_allocated_checklists pac ,
per_allocated_tasks pat ,
per_tasks_in_checklist_b ptc ,
hrq_ptcpnt_responses_v hprv,
hrq_qstnr_all_qstns_v hqaqv,
hrq_questions_vl hqv

            WHERE pac.person_id             	= ppf.person_id
            and pac.allocated_checklist_id	=pat.allocated_checklist_id
            and pat.status 					= 'COM'
            and ptc.task_in_checklist_id 	= pat.task_in_checklist_id    
            and hprv.questionnaire_id 		= pat.questionnaire_id