VIEW: APPS.HRBV_GRADE

Source

View Text - Preformatted

SELECT grdT.name grade_name ,grd.short_name short_name ,'_KF:PER:GRD:gdef' ,grd.date_from date_from ,grd.date_to date_to ,grd.comments comments ,grd.sequence sequence ,grd.information_category information_category ,grd.information1 information1 ,grd.information2 information2 ,grd.information3 information3 ,grd.information4 information4 ,grd.information5 information5 ,grd.information6 information6 ,grd.information7 information7 ,grd.information8 information8 ,grd.information9 information9 ,grd.information10 information10 ,grd.information11 information11 ,grd.information12 information12 ,grd.information13 information13 ,grd.information14 information14 ,grd.information15 information15 ,grd.information16 information16 ,grd.information17 information17 ,grd.information18 information18 ,grd.information19 information19 ,grd.information20 information20 ,'_DF:PER:PER_GRADES:grd' ,hr_api.return_legislation_code(grd.business_group_id) legislation_code ,grd.business_group_id business_group_id ,grd.grade_id grade_id ,grd.grade_definition_id grade_definition_id ,grd.last_update_date last_update_date ,grd.last_updated_by last_updated_by ,grd.last_update_login last_update_login ,grd.created_by created_by ,grd.creation_date creation_date ,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_grade_definitions gdef ,per_grades grd ,per_grades_tl grdT WHERE gdef.grade_definition_id = grd.grade_definition_id AND gdef.enabled_flag = 'Y' AND grd.grade_id = grdT.grade_id AND grdT.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT GRDT.NAME GRADE_NAME
, GRD.SHORT_NAME SHORT_NAME
, '_KF:PER:GRD:GDEF'
, GRD.DATE_FROM DATE_FROM
, GRD.DATE_TO DATE_TO
, GRD.COMMENTS COMMENTS
, GRD.SEQUENCE SEQUENCE
, GRD.INFORMATION_CATEGORY INFORMATION_CATEGORY
, GRD.INFORMATION1 INFORMATION1
, GRD.INFORMATION2 INFORMATION2
, GRD.INFORMATION3 INFORMATION3
, GRD.INFORMATION4 INFORMATION4
, GRD.INFORMATION5 INFORMATION5
, GRD.INFORMATION6 INFORMATION6
, GRD.INFORMATION7 INFORMATION7
, GRD.INFORMATION8 INFORMATION8
, GRD.INFORMATION9 INFORMATION9
, GRD.INFORMATION10 INFORMATION10
, GRD.INFORMATION11 INFORMATION11
, GRD.INFORMATION12 INFORMATION12
, GRD.INFORMATION13 INFORMATION13
, GRD.INFORMATION14 INFORMATION14
, GRD.INFORMATION15 INFORMATION15
, GRD.INFORMATION16 INFORMATION16
, GRD.INFORMATION17 INFORMATION17
, GRD.INFORMATION18 INFORMATION18
, GRD.INFORMATION19 INFORMATION19
, GRD.INFORMATION20 INFORMATION20
, '_DF:PER:PER_GRADES:GRD'
, HR_API.RETURN_LEGISLATION_CODE(GRD.BUSINESS_GROUP_ID) LEGISLATION_CODE
, GRD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GRD.GRADE_ID GRADE_ID
, GRD.GRADE_DEFINITION_ID GRADE_DEFINITION_ID
, GRD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GRD.LAST_UPDATED_BY LAST_UPDATED_BY
, GRD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GRD.CREATED_BY CREATED_BY
, GRD.CREATION_DATE CREATION_DATE
, 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_GRADE_DEFINITIONS GDEF
, PER_GRADES GRD
, PER_GRADES_TL GRDT
WHERE GDEF.GRADE_DEFINITION_ID = GRD.GRADE_DEFINITION_ID
AND GDEF.ENABLED_FLAG = 'Y'
AND GRD.GRADE_ID = GRDT.GRADE_ID
AND GRDT.LANGUAGE = USERENV('LANG') WITH READ ONLY