View: PA_ALL_COMPETENCES_LOV_V

Product:	PA - Projects
Description:	This view returns all competences
Implementation/DBA Data:	APPS.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