The report captures responses from the most recent entry instead of all entries for Guided Journeys

Summary:When a single user submits Guided Journey responses for multiple employees, the report is only capturing responses from the most recent entry instead of all entries. This issue does not occur when the user performs only one transaction per day. Has anyone faced this issue and have potential solutions to address it?
Tables used:
PER_CHK_GUIDED_RESPONSES
HRQ_QSTNR_RESPONSES
HRQ_QSTN_RESPONSES

Content (please ensure you mask any confidential information):

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

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

SELECT distinct
hsb.subscriber_code,
qtl.QUESTION_TEXT,