DBA Data[Home] [Help]

VIEW: APPS.HR_GRADE_BASE_V

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')