View: HR_GRADE_JOB_BASE_V

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

View Text

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 GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
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 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))

Columns