VIEW: APPS.HRI_GRD_LOV_V

Source

View Text - Preformatted

SELECT grd.grade_id grade_id ,gdt.name grade_name FROM per_grades grd ,per_grades_tl gdt WHERE grd.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,grd.business_group_id) AND grd.grade_id = gdt.grade_id AND gdt.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT GRD.GRADE_ID GRADE_ID
, GDT.NAME GRADE_NAME
FROM PER_GRADES GRD
, PER_GRADES_TL GDT
WHERE GRD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, GRD.BUSINESS_GROUP_ID)
AND GRD.GRADE_ID = GDT.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG') WITH READ ONLY