VIEW: APPS.HRI_CL_CMPTNC_N_V

Source

View Text - Preformatted

SELECT cmp.competence_id ID , cmp.name VALUE , cmp.date_from START_DATE , NVL(cmp.date_to, hr_general.end_of_time) END_DATE , cmp.name ORDER_BY , cmp.business_group_id business_group_id , CASE WHEN ( cmp.business_group_id IS NULL OR cmp.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,cmp.business_group_id) ) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_competences cmp WITH READ ONLY

View Text - HTML Formatted

SELECT CMP.COMPETENCE_ID ID
, CMP.NAME VALUE
, CMP.DATE_FROM START_DATE
, NVL(CMP.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, CMP.NAME ORDER_BY
, CMP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN ( CMP.BUSINESS_GROUP_ID IS NULL OR CMP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CMP.BUSINESS_GROUP_ID) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_COMPETENCES CMP WITH READ ONLY