Trying to find the job details from the grade table through valid grades table

Summary:

We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs in the Per_valid_grades_f table for one grade ID.

Please help me to get the correct joins.

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT PVGF.*

FROM

PER_VALID_GRADES_F PVGF
,PER_JOBS_F_VL PJFV

WHERE 1=1

and PGFV.grade_id = PVGF.grade_id
and SYSDATE between PVGF.EFFECTIVE_START_DATE and PVGF.EFFECTIVE_END_DATE

and PVGF.job_id = PJFV.job_id