Link learning evaluation questionnaire to learning assignment in Bi publisher

Hello,

I have a requirement in BI Publisher in wich I need to extract the answer of a specific question from the offering evaluation (in learning)

My base is that, however it's missing the link between the offering assignment and the questions. Could you please adivse on which table I could use in order to correct it ?

LEFT JOIN

(    SELECT        
asg_learner.learner_id,       
q.question_text,       
asg_learner.assignment_record_id,       
resp.long_text   

FROM wlf_assignment_records_f asg_learner   
JOIN hrq_qstnr_pcpt_responses_v resp       
ON to_char(asg_learner.learner_id) = to_char(resp.participant_id)