[Home] [Help]
View: HR_GRADE_BASE_V
View Text
SELECT GRT.NAME
, GRD.GRADE_ID
, GRD.DATE_FROM
, GRD.DATE_TO
, GRD.BUSINESS_GROUP_ID
FROM PER_GRADES_TL GRT
, PER_GRADES GRD
WHERE GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
Columns
Name |
NAME |
GRADE_ID |
DATE_FROM |
DATE_TO |
BUSINESS_GROUP_ID |