Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_RESOURCE_COMPETENCES_V |
SELECT COMP_ELE.ROWID
, COMP_ELE.PERSON_ID
, COMP_ELE.COMPETENCE_ID
, COMP_ELE.COMPETENCE_ELEMENT_ID
, COMP.COMPETENCE_ALIAS
, COMP.NAME
, COMP_ELE.OBJECT_VERSION_NUMBER
, COMP_ELE.EFFECTIVE_DATE_FROM
, COMP_ELE.EFFECTIVE_DATE_TO
, COMP.DESCRIPTION
, COMP_ELE.PROFICIENCY_LEVEL_ID
, RL.STEP_VALUE
, COMP_ELE.LAST_UPDATE_DATE
, DECODE(COMP.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
, 'N'
FROM PER_COMPETENCE_ELEMENTS COMP_ELE
, PER_COMPETENCES COMP
, PER_RATING_LEVELS RL
WHERE COMP_ELE.COMPETENCE_ID = COMP.COMPETENCE_ID
AND COMP_ELE.PROFICIENCY_LEVEL_ID = RL.RATING_LEVEL_ID (+)
AND COMP_ELE.PERSON_ID IS NOT NULL
AND COMP_ELE.COMPETENCE_ELEMENT_ID NOT IN (SELECT NVL(COMPETENCE_ELEMENT_ID
, -1)
FROM PA_COMPETENCE_PROFILES) UNION SELECT COMP_TMP.ROWID
, COMP_TMP.PERSON_ID
, COMP_TMP.COMPETENCE_ID
, COMP_TMP.COMPETENCE_ELEMENT_ID
, COMP_TMP.COMPETENCE_ALIAS
, COMP_TMP.COMPETENCE_NAME
, COMP_TMP.OBJECT_VERSION_NUMBER
, COMP_TMP.EFFECTIVE_DATE_FROM
, TO_DATE(NULL)
, COMP_TMP.DESCRIPTION
, COMP_TMP.RATING_LEVEL_ID
, COMP_TMP.RATING_LEVEL_VALUE
, COMP_TMP.LAST_UPDATE_DATE
, DECODE(COMP_TMP.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
, 'Y'
FROM PA_COMPETENCE_PROFILES COMP_TMP