VIEW: APPS.PA_GLOBAL_COMPETENCES_LOV_V

Source

View Text - Preformatted

SELECT comp.competence_id, comp.competence_alias, comp.name, comp.description FROM per_competences comp WHERE business_group_id IS NULL AND EXISTS (SELECT competence_id FROM per_competence_levels_v comp_lvl WHERE comp_lvl.competence_id = comp.competence_id)

View Text - HTML Formatted

SELECT COMP.COMPETENCE_ID
, COMP.COMPETENCE_ALIAS
, COMP.NAME
, COMP.DESCRIPTION
FROM PER_COMPETENCES COMP
WHERE BUSINESS_GROUP_ID IS NULL
AND EXISTS (SELECT COMPETENCE_ID
FROM PER_COMPETENCE_LEVELS_V COMP_LVL
WHERE COMP_LVL.COMPETENCE_ID = COMP.COMPETENCE_ID)