VIEW: APPS.PA_SETUP_JOB_LEVELS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)