SELECT DISTINCT CEL.QUALIFICATION_TYPE_ID , QTT.NAME FROM PER_COMPETENCE_ELEMENTS CEL ,PER_QUALIFICATION_TYPES_TL QTT WHERE CEL.TYPE = 'QUALIFICATION' AND CEL.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID AND QTT.LANGUAGE = userenv('LANG')
SELECT DISTINCT CEL.QUALIFICATION_TYPE_ID
, QTT.NAME
FROM PER_COMPETENCE_ELEMENTS CEL
, PER_QUALIFICATION_TYPES_TL QTT
WHERE CEL.TYPE = 'QUALIFICATION'
AND CEL.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID
AND QTT.LANGUAGE = USERENV('LANG')
|
|
|