VIEW: APPS.HRBV_RATING_LEVELS_V

Source

View Text - Preformatted

SELECT RTL.STEP_VALUE, RTLT.NAME, RTL.BEHAVIOURAL_INDICATOR, '_DF:PER:PER_RATING_LEVELS:RTL', RTL.RATING_LEVEL_ID, RTL.BUSINESS_GROUP_ID, RTL.RATING_SCALE_ID, RTL.COMPETENCE_ID, RTL.LAST_UPDATE_DATE, RTL.LAST_UPDATED_BY, RTL.CREATED_BY, RTL.CREATION_DATE, CASE WHEN RTL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, RTL.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_RATING_LEVELS RTL, PER_RATING_LEVELS_TL RTLT WHERE RTL.RATING_LEVEL_ID = RTLT.RATING_LEVEL_ID AND RTLT.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT RTL.STEP_VALUE
, RTLT.NAME
, RTL.BEHAVIOURAL_INDICATOR
, '_DF:PER:PER_RATING_LEVELS:RTL'
, RTL.RATING_LEVEL_ID
, RTL.BUSINESS_GROUP_ID
, RTL.RATING_SCALE_ID
, RTL.COMPETENCE_ID
, RTL.LAST_UPDATE_DATE
, RTL.LAST_UPDATED_BY
, RTL.CREATED_BY
, RTL.CREATION_DATE
, CASE WHEN RTL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, RTL.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_RATING_LEVELS RTL
, PER_RATING_LEVELS_TL RTLT
WHERE RTL.RATING_LEVEL_ID = RTLT.RATING_LEVEL_ID
AND RTLT.LANGUAGE = USERENV('LANG') WITH READ ONLY