VIEW: APPS.HRBV_COMPETENCE_ELEMENTS_V

Source

View Text - Preformatted

SELECT CEL.TYPE, HR_BIS.BIS_DECODE_LOOKUP('COMPETENCE_ELEMENT_TYPE',CEL.TYPE), CEL.MANDATORY, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CEL.MANDATORY), CEL.EFFECTIVE_DATE_FROM, CEL.EFFECTIVE_DATE_TO, CEL.GROUP_COMPETENCE_TYPE, CEL.COMPETENCE_TYPE, HR_BIS.BIS_DECODE_LOOKUP('COMPETENCE_TYPE',CEL.COMPETENCE_TYPE), CEL.SEQUENCE_NUMBER, CEL.NORMAL_ELAPSE_DURATION, CEL.NORMAL_ELAPSE_DURATION_UNIT, HR_BIS.BIS_DECODE_LOOKUP('ELAPSE_DURATION',CEL.NORMAL_ELAPSE_DURATION_UNIT), CEL.SOURCE_OF_PROFICIENCY_LEVEL, HR_BIS.BIS_DECODE_LOOKUP('PROFICIENCY_SOURCE',CEL.SOURCE_OF_PROFICIENCY_LEVEL), CEL.LINE_SCORE, CEL.CERTIFICATION_DATE, CEL.CERTIFICATION_METHOD, HR_BIS.BIS_DECODE_LOOKUP('CERTIFICATION_METHOD',CEL.CERTIFICATION_METHOD), CEL.NEXT_CERTIFICATION_DATE, CEL.COMMENTS, CEL.OBJECT_NAME, CEL.UNIT_STANDARD_TYPE, CEL.STATUS, CEL.INFORMATION_CATEGORY, CEL.INFORMATION1, CEL.INFORMATION2, CEL.INFORMATION3, CEL.INFORMATION4, CEL.INFORMATION5, CEL.INFORMATION6, CEL.INFORMATION7, CEL.INFORMATION8, CEL.INFORMATION9, CEL.INFORMATION10, CEL.INFORMATION11, CEL.INFORMATION12, CEL.INFORMATION13, CEL.INFORMATION14, CEL.INFORMATION15, CEL.INFORMATION16, CEL.INFORMATION17, CEL.INFORMATION18, CEL.INFORMATION19, CEL.INFORMATION20, CEL.ACHIEVED_DATE, '_DF:PER:PER_COMPETENCE_ELEMENTS:CEL', CEL.COMPETENCE_ELEMENT_ID, CEL.BUSINESS_GROUP_ID, CEL.COMPETENCE_ID, CEL.MEMBER_COMPETENCE_SET_ID, CEL.PROFICIENCY_LEVEL_ID, CEL.HIGH_PROFICIENCY_LEVEL_ID, CEL.WEIGHTING_LEVEL_ID, CEL.RATING_LEVEL_ID, CEL.PERSON_ID, CEL.ENTERPRISE_ID, CEL.JOB_ID, CEL.VALID_GRADE_ID, CEL.POSITION_ID, CEL.ORGANIZATION_ID, CEL.WORK_ITEM_ID, CEL.COMPETENCE_SET_ID, CEL.PARENT_COMPETENCE_ELEMENT_ID, CEL.ACTIVITY_VERSION_ID, CEL.ASSESSMENT_ID, CEL.ASSESSMENT_TYPE_ID, CEL.OBJECT_ID, CEL.PARTY_ID, CEL.QUALIFICATION_TYPE_ID, CEL.LAST_UPDATE_DATE, CEL.LAST_UPDATED_BY, CEL.CREATED_BY, CEL.CREATION_DATE, CASE WHEN CEL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CEL.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_COMPETENCE_ELEMENTS CEL WITH READ ONLY

View Text - HTML Formatted

SELECT CEL.TYPE
, HR_BIS.BIS_DECODE_LOOKUP('COMPETENCE_ELEMENT_TYPE'
, CEL.TYPE)
, CEL.MANDATORY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CEL.MANDATORY)
, CEL.EFFECTIVE_DATE_FROM
, CEL.EFFECTIVE_DATE_TO
, CEL.GROUP_COMPETENCE_TYPE
, CEL.COMPETENCE_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('COMPETENCE_TYPE'
, CEL.COMPETENCE_TYPE)
, CEL.SEQUENCE_NUMBER
, CEL.NORMAL_ELAPSE_DURATION
, CEL.NORMAL_ELAPSE_DURATION_UNIT
, HR_BIS.BIS_DECODE_LOOKUP('ELAPSE_DURATION'
, CEL.NORMAL_ELAPSE_DURATION_UNIT)
, CEL.SOURCE_OF_PROFICIENCY_LEVEL
, HR_BIS.BIS_DECODE_LOOKUP('PROFICIENCY_SOURCE'
, CEL.SOURCE_OF_PROFICIENCY_LEVEL)
, CEL.LINE_SCORE
, CEL.CERTIFICATION_DATE
, CEL.CERTIFICATION_METHOD
, HR_BIS.BIS_DECODE_LOOKUP('CERTIFICATION_METHOD'
, CEL.CERTIFICATION_METHOD)
, CEL.NEXT_CERTIFICATION_DATE
, CEL.COMMENTS
, CEL.OBJECT_NAME
, CEL.UNIT_STANDARD_TYPE
, CEL.STATUS
, CEL.INFORMATION_CATEGORY
, CEL.INFORMATION1
, CEL.INFORMATION2
, CEL.INFORMATION3
, CEL.INFORMATION4
, CEL.INFORMATION5
, CEL.INFORMATION6
, CEL.INFORMATION7
, CEL.INFORMATION8
, CEL.INFORMATION9
, CEL.INFORMATION10
, CEL.INFORMATION11
, CEL.INFORMATION12
, CEL.INFORMATION13
, CEL.INFORMATION14
, CEL.INFORMATION15
, CEL.INFORMATION16
, CEL.INFORMATION17
, CEL.INFORMATION18
, CEL.INFORMATION19
, CEL.INFORMATION20
, CEL.ACHIEVED_DATE
, '_DF:PER:PER_COMPETENCE_ELEMENTS:CEL'
, CEL.COMPETENCE_ELEMENT_ID
, CEL.BUSINESS_GROUP_ID
, CEL.COMPETENCE_ID
, CEL.MEMBER_COMPETENCE_SET_ID
, CEL.PROFICIENCY_LEVEL_ID
, CEL.HIGH_PROFICIENCY_LEVEL_ID
, CEL.WEIGHTING_LEVEL_ID
, CEL.RATING_LEVEL_ID
, CEL.PERSON_ID
, CEL.ENTERPRISE_ID
, CEL.JOB_ID
, CEL.VALID_GRADE_ID
, CEL.POSITION_ID
, CEL.ORGANIZATION_ID
, CEL.WORK_ITEM_ID
, CEL.COMPETENCE_SET_ID
, CEL.PARENT_COMPETENCE_ELEMENT_ID
, CEL.ACTIVITY_VERSION_ID
, CEL.ASSESSMENT_ID
, CEL.ASSESSMENT_TYPE_ID
, CEL.OBJECT_ID
, CEL.PARTY_ID
, CEL.QUALIFICATION_TYPE_ID
, CEL.LAST_UPDATE_DATE
, CEL.LAST_UPDATED_BY
, CEL.CREATED_BY
, CEL.CREATION_DATE
, CASE WHEN CEL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CEL.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_COMPETENCE_ELEMENTS CEL WITH READ ONLY