VIEW: APPS.HRI_CL_GRADE_N_V

Source

View Text - Preformatted

SELECT grd.grade_id ID , grd.name VALUE , grd.date_from start_date , nvl(grd.date_to,hr_general.end_of_time) end_date , grd.name order_by , grd.business_group_id business_group_id , CASE WHEN( grd.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,grd.business_group_id) ) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM /*------------------------------------*/ per_grades grd WITH READ ONLY

View Text - HTML Formatted

SELECT GRD.GRADE_ID ID
, GRD.NAME VALUE
, GRD.DATE_FROM START_DATE
, NVL(GRD.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, GRD.NAME ORDER_BY
, GRD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN( GRD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, GRD.BUSINESS_GROUP_ID) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM /*------------------------------------*/ PER_GRADES GRD WITH READ ONLY