Query: Grade Rates

select
    pr.name                       "Rate",
    --
    pgt.name                      "Grade Name",
    fcv.name                      "Currency",
    pgr.value                     "Value",
    pgr.minimum                   "Minimum",
    pgr.maximum                   "Maximum",
    pgr.mid_value                 "Mid Value",
    pgr.effective_start_date      "Eff: Dates From",
    pgr.effective_end_date        "Eff: Dates To",
    --
    pgt.grade_id,
    pr.rate_id  
from
    per_grades_tl pgt,
    pay_grade_rules_f pgr,
    pay_rates pr    ,
    fnd_currencies_vl fcv  
where
    1=1
and pgt.grade_id(+) = pgr.grade_or_spinal_point_id
and pr.rate_id = pgr.rate_id
and fcv.currency_code(+) = pgr.currency_code
--
and pr.name = 'Standard Hourly Rates'
order by
    1,2,3,4