Query for getting the Competences attached to an Assessment Template

SELECT
pce.group_competence_type,
pc.name,
pce1.attribute1
FROM
per_competence_elements     pce,
per_competence_elements     pce1,
per_competences             pc
WHERE
pce.assessment_type_id = <P_ASSESSMENT_TYPE_ID>
AND UPPER(pce.type) = UPPER('ASSESSMENT_GROUP')
AND pce1.parent_competence_element_id = pce.competence_element_id
AND UPPER(pce1.type) = UPPER('ASSESSMENT_COMPETENCE')
and pce1.competence_id = pc.competence_id;