SELECT GRT.NAME , GRD.GRADE_ID , VGJ.DATE_FROM , VGJ.DATE_TO , GRD.BUSINESS_GROUP_ID , JOB.JOB_ID , LKP.MEANING VALID_FOR_JOB FROM HR_LOOKUPS LKP , PER_VALID_GRADES VGJ , PER_GRADES_TL GRT , PER_GRADES GRD , PER_JOBS JOB WHERE GRD.GRADE_ID=VGJ.GRADE_ID AND VGJ.DATE_FROM BETWEEN GRD.DATE_FROM AND NVL(GRD.DATE_TO , VGJ.DATE_FROM+1) AND LKP.LOOKUP_TYPE='YES_NO' AND LKP.LOOKUP_CODE='Y' AND VGJ.JOB_ID=JOB.JOB_ID AND JOB.DATE_FROM < NVL(GRD.DATE_TO , JOB.DATE_FROM+1) AND NVL(JOB.DATE_TO , GRD.DATE_FROM+1) > GRD.DATE_FROM AND GRT.GRADE_ID = GRD.GRADE_ID AND GRT.LANGUAGE = USERENV('LANG') UNION SELECT GRT.NAME , GRD.GRADE_ID , GRD.DATE_FROM , GRD.DATE_TO , GRD.BUSINESS_GROUP_ID , JOB.JOB_ID , LKP.MEANING VALID_FOR_JOB FROM HR_LOOKUPS LKP , PER_GRADES_TL GRT , PER_GRADES GRD , PER_JOBS JOB WHERE LKP.LOOKUP_TYPE='YES_NO' AND LKP.LOOKUP_CODE='N' AND GRT.GRADE_ID = GRD.GRADE_ID AND GRT.LANGUAGE = USERENV('LANG') AND JOB.DATE_FROM < NVL(GRD.DATE_TO , JOB.DATE_FROM+1) AND NVL(JOB.DATE_TO , GRD.DATE_FROM+1) > GRD.DATE_FROM AND GRD.BUSINESS_GROUP_ID+0=JOB.BUSINESS_GROUP_ID+0 AND NOT EXISTS (SELECT NULL FROM PER_VALID_GRADES VGJ WHERE JOB.JOB_ID=VGJ.JOB_ID AND GRD.GRADE_ID=VGJ.GRADE_ID AND VGJ.DATE_FROM BETWEEN GRD.DATE_FROM AND NVL(GRD.DATE_TO , VGJ. DATE_FROM+1))