VIEW: APPS.HR_USJOB_LOV_V

Source

View Text - Preformatted

SELECT pj.job_id, pjt.name job_name, pj.business_group_id, pj.date_from, pj.date_to, hlc.meaning flsa_status from per_jobs_tl pjt, per_jobs pj, hr_lookups hlc WHERE pjt.job_id = pj.job_id and pjt.language = userenv('LANG') and hlc.lookup_code(+)= pj.job_information3 and hlc.lookup_type(+)='US_EXEMPT_NON_EXEMPT'

View Text - HTML Formatted

SELECT PJ.JOB_ID
, PJT.NAME JOB_NAME
, PJ.BUSINESS_GROUP_ID
, PJ.DATE_FROM
, PJ.DATE_TO
, HLC.MEANING FLSA_STATUS
FROM PER_JOBS_TL PJT
, PER_JOBS PJ
, HR_LOOKUPS HLC
WHERE PJT.JOB_ID = PJ.JOB_ID
AND PJT.LANGUAGE = USERENV('LANG')
AND HLC.LOOKUP_CODE(+)= PJ.JOB_INFORMATION3
AND HLC.LOOKUP_TYPE(+)='US_EXEMPT_NON_EXEMPT'