View: HR_GRADE_JPG_LOV_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_GRADE_JPG_LOV_V

View Text

SELECT GRT.NAME
, GRD.GRADE_ID
, PVG.DATE_FROM
, PVG.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS.POSITION_ID
, POS.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_VALID_GRADES PVG
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS
WHERE GRD.GRADE_ID=PVG.GRADE_ID
AND PVG.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG.DATE_FROM+1)
AND LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='N'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='Y'
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND PVG.POSITION_ID=POS.POSITION_ID
AND POS.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS.DATE_EFFECTIVE+1)
AND NVL(POS.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG2
WHERE PVG2.JOB_ID =POS.JOB_ID
AND PVG2.GRADE_ID=PVG.GRADE_ID
AND PVG2.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG2.DATE_FROM+1)) UNION SELECT GRT.NAME
, GRD.GRADE_ID
, PVG.DATE_FROM
, PVG.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS.POSITION_ID
, POS.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_VALID_GRADES PVG
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS
WHERE GRD.GRADE_ID=PVG.GRADE_ID
AND PVG.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG.DATE_FROM+1)
AND LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='Y'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='N'
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND PVG.JOB_ID =POS.JOB_ID
AND POS.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS.DATE_EFFECTIVE+1)
AND NVL(POS.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG2
WHERE PVG2.POSITION_ID =POS.POSITION_ID
AND PVG2.GRADE_ID=PVG.GRADE_ID
AND PVG2.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG2.DATE_FROM+1)) UNION SELECT GRT.NAME
, GRD.GRADE_ID
, PVG.DATE_FROM
, PVG.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS.POSITION_ID
, POS.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_VALID_GRADES PVG
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS
WHERE GRD.GRADE_ID=PVG.GRADE_ID
AND PVG.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG.DATE_FROM+1)
AND LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='Y'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='Y'
AND PVG.JOB_ID=POS.JOB_ID
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND PVG.POSITION_ID=POS.POSITION_ID
AND POS.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS.DATE_EFFECTIVE+1)
AND NVL(POS.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM UNION SELECT GRT.NAME
, GRD.GRADE_ID
, GRD.DATE_FROM
, GRD.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS.POSITION_ID
, POS.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS
WHERE LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='N'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='N'
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND POS.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS.DATE_EFFECTIVE+1)
AND NVL(POS.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG2
WHERE PVG2.POSITION_ID=POS.POSITION_ID
AND PVG2.GRADE_ID=GRD.GRADE_ID
AND PVG2.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG2.DATE_FROM+1))
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG3
WHERE PVG3.JOB_ID=POS.JOB_ID
AND PVG3.GRADE_ID=GRD.GRADE_ID
AND PVG3.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG3.DATE_FROM+1))

Columns