VIEW: APPS.HRI_MB_CMPTNC_PERSNL_V

Source

View Text - Preformatted

SELECT 1 row_indicator , plvl.scale_level_value scale_level_value , plvl.rank_level_value rank_level_value , plvl.nrmlzd_scale_level_value nrmlzd_scale_level_value , plvl.nrmlzd_rank_level_value nrmlzd_rank_level_value , NVL(cper.effective_date_from,hr_general.start_of_time) effective_start_date , NVL(cper.effective_date_to,hr_general.end_of_time) effective_end_date , cper.person_id person_id , cper.business_group_id business_group_id , cper.competence_id competence_id , NVL(cper.proficiency_level_id,-1) persnl_level_id , GREATEST(cper.last_update_date,hr_general.start_of_time ,NVL(plvl.last_change_date,hr_general.start_of_time) ) last_change_date , CASE WHEN cper.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,cper.business_group_id) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_competence_elements cper , hri_cs_cmptnc_lvl_ct plvl WHERE cper.type = 'PERSONAL' AND cper.competence_id = plvl.competence_id AND NVL(cper.proficiency_level_id, -1) = plvl.level_id WITH READ ONLY

View Text - HTML Formatted

SELECT 1 ROW_INDICATOR
, PLVL.SCALE_LEVEL_VALUE SCALE_LEVEL_VALUE
, PLVL.RANK_LEVEL_VALUE RANK_LEVEL_VALUE
, PLVL.NRMLZD_SCALE_LEVEL_VALUE NRMLZD_SCALE_LEVEL_VALUE
, PLVL.NRMLZD_RANK_LEVEL_VALUE NRMLZD_RANK_LEVEL_VALUE
, NVL(CPER.EFFECTIVE_DATE_FROM
, HR_GENERAL.START_OF_TIME) EFFECTIVE_START_DATE
, NVL(CPER.EFFECTIVE_DATE_TO
, HR_GENERAL.END_OF_TIME) EFFECTIVE_END_DATE
, CPER.PERSON_ID PERSON_ID
, CPER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CPER.COMPETENCE_ID COMPETENCE_ID
, NVL(CPER.PROFICIENCY_LEVEL_ID
, -1) PERSNL_LEVEL_ID
, GREATEST(CPER.LAST_UPDATE_DATE
, HR_GENERAL.START_OF_TIME
, NVL(PLVL.LAST_CHANGE_DATE
, HR_GENERAL.START_OF_TIME) ) LAST_CHANGE_DATE
, CASE WHEN CPER.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CPER.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_COMPETENCE_ELEMENTS CPER
, HRI_CS_CMPTNC_LVL_CT PLVL
WHERE CPER.TYPE = 'PERSONAL'
AND CPER.COMPETENCE_ID = PLVL.COMPETENCE_ID
AND NVL(CPER.PROFICIENCY_LEVEL_ID
, -1) = PLVL.LEVEL_ID WITH READ ONLY