I have tried to use the syntax provided in the link, but i am executing the below query i am getting an error

select *
from ( pivot
(' SELECT
PD.NAME AS DEPT_NAME,
PJFV.NAME AS JOB_NAME,
COUNT(PAPF.PERSON_NUMBER) AS SID

FROM
PER_ALL_PEOPLE_F PAPF,
PER_ALL_ASSIGNMENTS_M PAAM,
PER_JOBS_F_VL PJFV,
PER_DEPARTMENTS PD

WHERE
PAPF.PERSON_ID = PAAM.PERSON_ID
AND PAAM.JOB_ID = PJFV.JOB_ID
AND PAAM.ORGANIZATION_ID = PD.ORGANIZATION_ID
AND PAAM.ASSIGNMENT_TYPE = 'E'
AND PAAM.PRIMARY_FLAG = 'Y'
AND PAAM.PRIMARY_ASSIGNMENT_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE
GROUP BY PD.NAME,PJFV.NAME '
)
)

Error is "ORA-00907: missing right parenthesis"