Fetching Questionaire responses within Oracle checklist or Journey

select ans.LONG_TEXT from

HRQ_QSTN_ANSWERS_VL ans

where ans.ANSWER_CODE in

(SELECT trim(COLUMN_VALUE) ANSWER_LIST

FROM ( (select qstn.ANSWER_LIST

from Per_allocated_tasks task,

HRQ_QSTNR_PCPT_RESPONSES_V qstn

where 1=1

and task.ACTION_TYPE = 'ORA_CHK_QUESTIONNAIRE'

and task.ALLOCATED_TASK_ID = qstn.PARTICIPANT_ID

and task.QUESTIONNAIRE_ID=qstn.QUESTIONNAIRE_ID

and task.PERFORMER_ORIG_SYSTEM = 'PERSON_NUMBER')), xmltable(('"' || REPLACE(ANSWER_LIST, ',', '","') || '"')))