VIEW: APPS.HRBV_COMPETENCES_V

Source

View Text - Preformatted

SELECT CPT.NAME, CPN.DESCRIPTION, CPN.DATE_FROM, CPN.DATE_TO, CPN.BEHAVIOURAL_INDICATOR, CPN.CERTIFICATION_REQUIRED, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CPN.CERTIFICATION_REQUIRED), CPN.EVALUATION_METHOD, HR_BIS.BIS_DECODE_LOOKUP('COMPETENCE_EVAL_TYPE',CPN.EVALUATION_METHOD), CPN.RENEWAL_PERIOD_FREQUENCY, CPN.RENEWAL_PERIOD_UNITS, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY',CPN.RENEWAL_PERIOD_UNITS), CPN.MAX_LEVEL, CPN.MIN_LEVEL, CPN.COMPETENCE_ALIAS, CPN.COMPETENCE_CLUSTER, HR_BIS.BIS_DECODE_LOOKUP('PER_COMPETENCE_CLUSTER',CPN.COMPETENCE_CLUSTER), CPN.CREDIT_TYPE, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_CREDIT_TYPE',CPN.CREDIT_TYPE), CPN.CREDITS, CPN.LEVEL_TYPE, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_LEVEL_TYPE',CPN.LEVEL_TYPE), CPN.LEVEL_NUMBER, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_LEVEL',CPN.LEVEL_NUMBER), CPN.FIELD, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_FIELD',CPN.FIELD), CPN.SUB_FIELD, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_SUB_FIELD',CPN.SUB_FIELD), CPN.PROVIDER, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_PROVIDER',CPN.PROVIDER), CPN.QA_ORGANIZATION, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_QA_ORG',CPN.QA_ORGANIZATION), CPN.INFORMATION_CATEGORY, CPN.INFORMATION1, CPN.INFORMATION2, CPN.INFORMATION3, CPN.INFORMATION4, CPN.INFORMATION5, CPN.INFORMATION6, CPN.INFORMATION7, CPN.INFORMATION8, CPN.INFORMATION9, CPN.INFORMATION10, CPN.INFORMATION11, CPN.INFORMATION12, CPN.INFORMATION13, CPN.INFORMATION14, CPN.INFORMATION15, CPN.INFORMATION16, CPN.INFORMATION17, CPN.INFORMATION18, CPN.INFORMATION19, CPN.INFORMATION20, '_DF:PER:PER_COMPETENCES:CPN', CPN.COMPETENCE_ID, CPN.BUSINESS_GROUP_ID, CPN.RATING_SCALE_ID, CPN.COMPETENCE_DEFINITION_ID, CPN.UNIT_STANDARD_ID, CPN.LAST_UPDATE_DATE, CPN.LAST_UPDATED_BY, CPN.CREATED_BY, CPN.CREATION_DATE, CASE WHEN CPN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CPN.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_COMPETENCES CPN, PER_COMPETENCES_TL CPT WHERE CPN.COMPETENCE_ID = CPT.COMPETENCE_ID AND CPT.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CPT.NAME
, CPN.DESCRIPTION
, CPN.DATE_FROM
, CPN.DATE_TO
, CPN.BEHAVIOURAL_INDICATOR
, CPN.CERTIFICATION_REQUIRED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CPN.CERTIFICATION_REQUIRED)
, CPN.EVALUATION_METHOD
, HR_BIS.BIS_DECODE_LOOKUP('COMPETENCE_EVAL_TYPE'
, CPN.EVALUATION_METHOD)
, CPN.RENEWAL_PERIOD_FREQUENCY
, CPN.RENEWAL_PERIOD_UNITS
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, CPN.RENEWAL_PERIOD_UNITS)
, CPN.MAX_LEVEL
, CPN.MIN_LEVEL
, CPN.COMPETENCE_ALIAS
, CPN.COMPETENCE_CLUSTER
, HR_BIS.BIS_DECODE_LOOKUP('PER_COMPETENCE_CLUSTER'
, CPN.COMPETENCE_CLUSTER)
, CPN.CREDIT_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_CREDIT_TYPE'
, CPN.CREDIT_TYPE)
, CPN.CREDITS
, CPN.LEVEL_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_LEVEL_TYPE'
, CPN.LEVEL_TYPE)
, CPN.LEVEL_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_LEVEL'
, CPN.LEVEL_NUMBER)
, CPN.FIELD
, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_FIELD'
, CPN.FIELD)
, CPN.SUB_FIELD
, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_SUB_FIELD'
, CPN.SUB_FIELD)
, CPN.PROVIDER
, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_PROVIDER'
, CPN.PROVIDER)
, CPN.QA_ORGANIZATION
, HR_BIS.BIS_DECODE_LOOKUP('PER_QUAL_FWK_QA_ORG'
, CPN.QA_ORGANIZATION)
, CPN.INFORMATION_CATEGORY
, CPN.INFORMATION1
, CPN.INFORMATION2
, CPN.INFORMATION3
, CPN.INFORMATION4
, CPN.INFORMATION5
, CPN.INFORMATION6
, CPN.INFORMATION7
, CPN.INFORMATION8
, CPN.INFORMATION9
, CPN.INFORMATION10
, CPN.INFORMATION11
, CPN.INFORMATION12
, CPN.INFORMATION13
, CPN.INFORMATION14
, CPN.INFORMATION15
, CPN.INFORMATION16
, CPN.INFORMATION17
, CPN.INFORMATION18
, CPN.INFORMATION19
, CPN.INFORMATION20
, '_DF:PER:PER_COMPETENCES:CPN'
, CPN.COMPETENCE_ID
, CPN.BUSINESS_GROUP_ID
, CPN.RATING_SCALE_ID
, CPN.COMPETENCE_DEFINITION_ID
, CPN.UNIT_STANDARD_ID
, CPN.LAST_UPDATE_DATE
, CPN.LAST_UPDATED_BY
, CPN.CREATED_BY
, CPN.CREATION_DATE
, CASE WHEN CPN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CPN.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_COMPETENCES CPN
, PER_COMPETENCES_TL CPT
WHERE CPN.COMPETENCE_ID = CPT.COMPETENCE_ID
AND CPT.LANGUAGE = USERENV('LANG') WITH READ ONLY