Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_COMPETENCES_V |
SELECT CMP.ROWID
, CMP.COMPETENCE_ID
, CMP.COMPETENCE_DEFINITION_ID
, CMD.ID_FLEX_NUM
, CPL.NAME
, CPL.COMPETENCE_ALIAS
, CMP.BUSINESS_GROUP_ID
, CMP.OBJECT_VERSION_NUMBER
, CPL.DESCRIPTION
, CMP.DATE_FROM
, CMP.DATE_TO
, PER_CPN_BUS.CHK_SET_RADIO_BUTTON(CMP.COMPETENCE_ID
, CMP.RATING_SCALE_ID)
, CPL.BEHAVIOURAL_INDICATOR
, CMP.CERTIFICATION_REQUIRED
, CMP.EVALUATION_METHOD
, HR_GENERAL.DECODE_LOOKUP('COMPETENCE_EVAL_TYPE'
, CMP.EVALUATION_METHOD)
, CMP.RENEWAL_PERIOD_FREQUENCY
, CMP.RENEWAL_PERIOD_UNITS
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, CMP.RENEWAL_PERIOD_UNITS)
, DECODE(CMP.RATING_SCALE_ID
, NULL
, CMP.MIN_LEVEL
, RSC.MIN_SCALE_STEP)
, DECODE(CMP.RATING_SCALE_ID
, NULL
, CMP.MAX_LEVEL
, RSC.MAX_SCALE_STEP)
, CMP.RATING_SCALE_ID
, RSL.NAME
, CMP.ATTRIBUTE_CATEGORY
, CMP.ATTRIBUTE1
, CMP.ATTRIBUTE2
, CMP.ATTRIBUTE3
, CMP.ATTRIBUTE4
, CMP.ATTRIBUTE5
, CMP.ATTRIBUTE6
, CMP.ATTRIBUTE7
, CMP.ATTRIBUTE8
, CMP.ATTRIBUTE9
, CMP.ATTRIBUTE10
, CMP.ATTRIBUTE11
, CMP.ATTRIBUTE12
, CMP.ATTRIBUTE13
, CMP.ATTRIBUTE14
, CMP.ATTRIBUTE15
, CMP.ATTRIBUTE16
, CMP.ATTRIBUTE17
, CMP.ATTRIBUTE18
, CMP.ATTRIBUTE19
, CMP.ATTRIBUTE20
, CMD.SEGMENT1
, CMD.SEGMENT2
, CMD.SEGMENT3
, CMD.SEGMENT4
, CMD.SEGMENT5
, CMD.SEGMENT6
, CMD.SEGMENT7
, CMD.SEGMENT8
, CMD.SEGMENT9
, CMD.SEGMENT10
, CMD.SEGMENT11
, CMD.SEGMENT12
, CMD.SEGMENT13
, CMD.SEGMENT14
, CMD.SEGMENT15
, CMD.SEGMENT16
, CMD.SEGMENT17
, CMD.SEGMENT18
, CMD.SEGMENT19
, CMD.SEGMENT20
, CMD.SEGMENT21
, CMD.SEGMENT22
, CMD.SEGMENT23
, CMD.SEGMENT24
, CMD.SEGMENT25
, CMD.SEGMENT26
, CMD.SEGMENT27
, CMD.SEGMENT28
, CMD.SEGMENT29
, CMD.SEGMENT30
, DECODE(CMP.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
, CMP.LAST_UPDATE_DATE
, CMP.LAST_UPDATED_BY
, CMP.LAST_UPDATE_LOGIN
, CMP.CREATED_BY
, CMP.CREATION_DATE
, CMP.COMPETENCE_CLUSTER
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_CLUSTER'
, CMP.COMPETENCE_CLUSTER)
, CMP.UNIT_STANDARD_ID
, CMP.CREDIT_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_CREDIT_TYPE'
, CMP.CREDIT_TYPE)
, CMP.CREDITS
, CMP.LEVEL_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL_TYPE'
, CMP.LEVEL_TYPE)
, CMP.LEVEL_NUMBER
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL'
, CMP.LEVEL_NUMBER)
, CMP.FIELD
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_FIELD'
, CMP.FIELD)
, CMP.SUB_FIELD
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_SUB_FIELD'
, CMP.SUB_FIELD)
, CMP.PROVIDER
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_PROVIDER'
, CMP.PROVIDER)
, CMP.QA_ORGANIZATION
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_QA_ORG'
, CMP.QA_ORGANIZATION)
, CMP.INFORMATION_CATEGORY
, CMP.INFORMATION1
, CMP.INFORMATION2
, CMP.INFORMATION3
, CMP.INFORMATION4
, CMP.INFORMATION5
, CMP.INFORMATION6
, CMP.INFORMATION7
, CMP.INFORMATION8
, CMP.INFORMATION9
, CMP.INFORMATION10
, CMP.INFORMATION11
, CMP.INFORMATION12
, CMP.INFORMATION13
, CMP.INFORMATION14
, CMP.INFORMATION15
, CMP.INFORMATION16
, CMP.INFORMATION17
, CMP.INFORMATION18
, CMP.INFORMATION19
, CMP.INFORMATION20
FROM PER_COMPETENCES CMP
, PER_COMPETENCES_TL CPL
, PER_COMPETENCE_DEFINITIONS CMD
, PER_RATING_SCALES RSC
, PER_RATING_SCALES_TL RSL
WHERE CMP.COMPETENCE_DEFINITION_ID = CMD.COMPETENCE_DEFINITION_ID
AND CPL.COMPETENCE_ID = CMP.COMPETENCE_ID
AND CPL.LANGUAGE = USERENV('LANG')
AND CMP.RATING_SCALE_ID = RSC.RATING_SCALE_ID(+)
AND CMP.RATING_SCALE_ID = RSL.RATING_SCALE_ID(+)
AND RSL.LANGUAGE(+) = USERENV('LANG')