Which tables to use for Grade Rate Minimum and Maximum Salary along with Grade code
Hi all,
I need to pull out Grade Rate details in a BI Report, which tables I should join ? I need Grade Code, Minimum Salary and Maximum Salary against that specific Grade code in a specific Legislative code. I used the below query but the Grade_Ladder_ID is blank in grate rate table. Any Idea how to achieve this ?
select
distinct
pgf.grade_code, prvf.minimum, prvf.maximum
from
PER_GRADES_F pgf, PER_GRADES_IN_LADDERS_F pgilf, per_rates_f prf, PER_RATE_VALUES_F prvf
where
pgf.GRADE_ID = pgilf.GRADE_ID
and prf.GRADE_LADDER_ID = pgilf.GRADE_LADDER_ID