Query: Position Valid Grades

select
    hapf.name                           "Position Name",
    --
    pgl.name                            "Grade",
    pg.date_from                        "Date From",
    --
    pg.date_to                          "Date To",
    hapf.position_id
from
    per_valid_grades pvg,
    per_grades pg,
    per_grades_tl pgl,
    hr_all_positions_f hapf
where 1=1
and pgl.grade_id = pg.grade_id
and pgl.language = userenv('LANG')
and pg.grade_id = pvg.grade_id
and pvg.position_id = hapf.position_id
--
and hapf.name like '1001.Operations Vice President';