VIEW: APPS.IRCFV_COMPETENCE_PROFILES

Source

View Text - Preformatted

SELECT pty.person_name candidate_name ,cpn.name competence_name ,cmp.effective_date_from date_from ,cmp.effective_date_to date_to ,nvl(cmp.effective_date_to, hr_general.end_of_time) date_to_nn ,rat.step_value level_step_value ,rat.name proficiency_level ,'_DF:PER:PER_COMPETENCE_ELEMENTS:cmp' ,'_KF:PER:CMP:cdef' ,cpn.competence_id competence_id ,pty.party_id party_id ,cmp.competence_element_id competence_element_id ,rat.rating_level_id rating_level_id ,cdef.competence_definition_id competence_definition_id FROM per_rating_levels rat ,hz_person_profiles pty ,irc_notification_preferences inp ,per_competences cpn ,per_competence_definitions cdef ,per_competence_elements cmp WHERE cpn.competence_id = cmp.competence_id AND cmp.proficiency_level_id = rat.rating_level_id (+) AND cmp.party_id = pty.party_id AND inp.allow_access = 'Y' AND pty.party_id = inp.party_id AND cmp.type = 'PERSONAL' AND cdef.competence_definition_id = cpn.competence_definition_id AND trunc(sysdate) between NVL(pty.effective_start_date, hr_general.start_of_time) and NVL(pty.effective_end_date , hr_general.end_of_time) WITH READ ONLY

View Text - HTML Formatted

SELECT PTY.PERSON_NAME CANDIDATE_NAME
, CPN.NAME COMPETENCE_NAME
, CMP.EFFECTIVE_DATE_FROM DATE_FROM
, CMP.EFFECTIVE_DATE_TO DATE_TO
, NVL(CMP.EFFECTIVE_DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO_NN
, RAT.STEP_VALUE LEVEL_STEP_VALUE
, RAT.NAME PROFICIENCY_LEVEL
, '_DF:PER:PER_COMPETENCE_ELEMENTS:CMP'
, '_KF:PER:CMP:CDEF'
, CPN.COMPETENCE_ID COMPETENCE_ID
, PTY.PARTY_ID PARTY_ID
, CMP.COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID
, RAT.RATING_LEVEL_ID RATING_LEVEL_ID
, CDEF.COMPETENCE_DEFINITION_ID COMPETENCE_DEFINITION_ID
FROM PER_RATING_LEVELS RAT
, HZ_PERSON_PROFILES PTY
, IRC_NOTIFICATION_PREFERENCES INP
, PER_COMPETENCES CPN
, PER_COMPETENCE_DEFINITIONS CDEF
, PER_COMPETENCE_ELEMENTS CMP
WHERE CPN.COMPETENCE_ID = CMP.COMPETENCE_ID
AND CMP.PROFICIENCY_LEVEL_ID = RAT.RATING_LEVEL_ID (+)
AND CMP.PARTY_ID = PTY.PARTY_ID
AND INP.ALLOW_ACCESS = 'Y'
AND PTY.PARTY_ID = INP.PARTY_ID
AND CMP.TYPE = 'PERSONAL'
AND CDEF.COMPETENCE_DEFINITION_ID = CPN.COMPETENCE_DEFINITION_ID
AND TRUNC(SYSDATE) BETWEEN NVL(PTY.EFFECTIVE_START_DATE
, HR_GENERAL.START_OF_TIME)
AND NVL(PTY.EFFECTIVE_END_DATE
, HR_GENERAL.END_OF_TIME) WITH READ ONLY