VIEW: APPS.HRFV_GRADES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,grd.name grade_name ,'_KF:PER:GRD:gdef' ,grd.date_from date_from ,grd.date_to date_to ,grd.comments comments ,grd.sequence sequence ,'_DF:PER:PER_GRADES:grd' ,grd.business_group_id business_group_id ,grd.grade_id grade_id ,gdef.grade_definition_id grade_definition_id FROM hr_all_organization_units_tl bgrT ,per_grade_definitions gdef ,per_grades grd WHERE gdef.grade_definition_id = grd.grade_definition_id AND gdef.enabled_flag = 'Y' AND grd.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND grd.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,grd.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, GRD.NAME GRADE_NAME
, '_KF:PER:GRD:GDEF'
, GRD.DATE_FROM DATE_FROM
, GRD.DATE_TO DATE_TO
, GRD.COMMENTS COMMENTS
, GRD.SEQUENCE SEQUENCE
, '_DF:PER:PER_GRADES:GRD'
, GRD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GRD.GRADE_ID GRADE_ID
, GDEF.GRADE_DEFINITION_ID GRADE_DEFINITION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_GRADE_DEFINITIONS GDEF
, PER_GRADES GRD
WHERE GDEF.GRADE_DEFINITION_ID = GRD.GRADE_DEFINITION_ID
AND GDEF.ENABLED_FLAG = 'Y'
AND GRD.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND GRD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, GRD.BUSINESS_GROUP_ID) WITH READ ONLY