Product: | PER - Human Resources |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PER_COMPETENCES_VL |
SELECT CPN.ROWID ROW_ID
, CPN.BUSINESS_GROUP_ID
, CPN.COMPETENCE_ID
, CPN.OBJECT_VERSION_NUMBER
, CPN.DATE_FROM
, CPN.DATE_TO
, CPN.CERTIFICATION_REQUIRED
, CPN.EVALUATION_METHOD
, CPN.RENEWAL_PERIOD_FREQUENCY
, CPN.RENEWAL_PERIOD_UNITS
, CPN.MAX_LEVEL
, CPN.MIN_LEVEL
, CPN.RATING_SCALE_ID
, CPN.ATTRIBUTE_CATEGORY
, CPN.ATTRIBUTE1
, CPN.ATTRIBUTE2
, CPN.ATTRIBUTE3
, CPN.ATTRIBUTE4
, CPN.ATTRIBUTE5
, CPN.ATTRIBUTE6
, CPN.ATTRIBUTE7
, CPN.ATTRIBUTE8
, CPN.ATTRIBUTE9
, CPN.ATTRIBUTE10
, CPN.ATTRIBUTE11
, CPN.ATTRIBUTE12
, CPN.ATTRIBUTE13
, CPN.ATTRIBUTE14
, CPN.ATTRIBUTE15
, CPN.ATTRIBUTE16
, CPN.ATTRIBUTE17
, CPN.ATTRIBUTE18
, CPN.ATTRIBUTE19
, CPN.ATTRIBUTE20
, CPN.LAST_UPDATE_DATE
, CPN.LAST_UPDATED_BY
, CPN.LAST_UPDATE_LOGIN
, CPN.CREATED_BY
, CPN.CREATION_DATE
, CPN.COMPETENCE_DEFINITION_ID
, CPL.NAME
, CPL.COMPETENCE_ALIAS
, CPL.BEHAVIOURAL_INDICATOR
, CPL.DESCRIPTION
FROM PER_COMPETENCES CPN
, PER_COMPETENCES_TL CPL
WHERE CPN.COMPETENCE_ID = CPL.COMPETENCE_ID
AND CPL.LANGUAGE = USERENV('LANG')