Activity Report Issue

Hi,

im working with a issue in my Activity report, that need course and offering info, the problem rise because of a excel course that they use the same activity for all offers, and a employee is in 2 offers with same name basically, the data appears to be mixing, i get duplicated lines for this course, but the activity completion from the 2nd one(the completed) here is my code:

WITH EMPLOYEE_DADOS AS (
SELECT

PPSL.PERSON_ID AS EMP_PERSON_ID,
PPNF.DISPLAY_NAME AS EMP_FULL_NAME,
PPTV.USER_PERSON_TYPE AS EMP_PERSON_TYPE,
(
SELECT MEANING
FROM HCM_LOOKUPS