[Home] [Help]
View: PA_ALL_COMPETENCES_LOV_V
View Text
SELECT COMP.COMPETENCE_ID
, COMP.COMPETENCE_ALIAS
, COMP.NAME
, COMP.DESCRIPTION
, COMP.BUSINESS_GROUP_ID
, BG.NAME
, PA_COMP_PROFILE_PUB.GET_SELECT_FLAG(COMP.COMPETENCE_ID)
, COMP.DATE_FROM
, COMP.DATE_TO
FROM PER_COMPETENCES COMP
, PER_BUSINESS_GROUPS BG
WHERE (EXISTS (SELECT COMPETENCE_ID
FROM PER_RATING_LEVELS COMP_LVL
WHERE COMP_LVL.COMPETENCE_ID = COMP.COMPETENCE_ID) OR EXISTS (SELECT COMPETENCE_ID
FROM PER_RATING_LEVELS LVL
WHERE LVL.RATING_SCALE_ID = COMP.RATING_SCALE_ID))
AND COMP.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID (+)
Columns
Name |
COMPETENCE_ID |
COMPETENCE_ALIAS |
COMPETENCE_NAME |
DESCRIPTION |
BUSINESS_GROUP_ID |
BUSINESS_GROUP_NAME |
SELECT_FLAG |
COMPETENCE_DATE_FROM |
COMPETENCE_DATE_TO |