View: PA_SETUP_JOB_LEVELS_V

Product:	PA - Projects
Description:	PA_SETUP_JOB_LEVELS_V is a view to be used in Job Levels LOV in Project Roles set up page or form UI.
Implementation/DBA Data:	APPS.PA_SETUP_JOB_LEVELS_V

View Text

SELECT DISTINCT NULL GRADE_ID
, NULL BUSINESS_GROUP_ID
, NULL GRADE_DEFINITION_ID
, PL.START_DATE_ACTIVE
, TO_NUMBER(PJEI.JEI_INFORMATION4)
, PL.END_DATE_ACTIVE
, NULL NAME
, PL.MEANING
FROM PER_JOBS PJ
, PER_JOB_EXTRA_INFO PJEI
, PA_LOOKUPS PL
WHERE PJ.JOB_GROUP_ID = NVL(PA_JOB_UTILS.GET_PROJ_RES_JOB_GROUP(NULL)
, PJ.JOB_GROUP_ID)
AND PJ.JOB_ID = PJEI.JOB_ID
AND PJEI.JEI_INFORMATION4 = PL.LOOKUP_CODE
AND PJEI.INFORMATION_TYPE = 'JOB CATEGORY'
AND PL.LOOKUP_TYPE = 'PROJECT_JOB_LEVEL'
AND PL.ENABLED_FLAG = 'Y'
AND (PL.END_DATE_ACTIVE >= SYSDATE OR PL.END_DATE_ACTIVE IS NULL)

Columns