View: HR_USJOB_LOV_V

Product:	PER - Human Resources
Description:	US specific view Retrieve jobs and FLSA status
Implementation/DBA Data:	APPS.HR_USJOB_LOV_V

View Text

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'

Columns