VIEW: APPS.HRI_CL_CMPTNC_LVL_V

Source

View Text - Preformatted

SELECT rlv.rating_level_id ID , rlv.name VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , rlv.step_value order_by , rlv.competence_id competence_id , rlv.rating_scale_id scale_id , CASE WHEN rlv.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, rlv.business_group_id) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_rating_levels rlv WHERE ( rlv.competence_id IS NOT NULL OR EXISTS (SELECT -1 FROM per_rating_scales rsc WHERE rlv.rating_scale_id = rsc.rating_scale_id AND rsc.type = 'PROFICIENCY' ) ) UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , -999 order_by , -1 competence_id , -1 scale_id , 'Y' bg_security_flag_code FROM dual

View Text - HTML Formatted

SELECT RLV.RATING_LEVEL_ID ID
, RLV.NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, RLV.STEP_VALUE ORDER_BY
, RLV.COMPETENCE_ID COMPETENCE_ID
, RLV.RATING_SCALE_ID SCALE_ID
, CASE WHEN RLV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, RLV.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_RATING_LEVELS RLV
WHERE ( RLV.COMPETENCE_ID IS NOT NULL OR EXISTS (SELECT -1
FROM PER_RATING_SCALES RSC
WHERE RLV.RATING_SCALE_ID = RSC.RATING_SCALE_ID
AND RSC.TYPE = 'PROFICIENCY' ) ) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -999 ORDER_BY
, -1 COMPETENCE_ID
, -1 SCALE_ID
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL