VIEW: APPS.PA_ALL_COMPETENCES_LOV_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)