View: PA_GLOBAL_COMPETENCES_LOV_V

Product:	PA - Projects
Description:	This view returns all the global competences
Implementation/DBA Data:	APPS.PA_GLOBAL_COMPETENCES_LOV_V

View Text

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)

Columns