[Home] [Help]
View: PAY_WCI_OCCUPATIONS_V
View Text
SELECT PWO.OCCUPATION_ID
, PWO.BUSINESS_GROUP_ID
, PWO.RATE_ID
, PWO.JOB_ID
, PJT.NAME
, PJ.DATE_FROM
, PJ.DATE_TO
, PWO.LAST_UPDATED_BY
, PWO.LAST_UPDATE_LOGIN
, PWO.LAST_UPDATE_DATE
, PWO.CREATED_BY
, PWO.CREATION_DATE
, PWO.OBJECT_VERSION_NUMBER
FROM PAY_WCI_OCCUPATIONS PWO
, PER_JOBS_TL PJT
, PER_JOBS PJ
WHERE PWO.JOB_ID = PJ.JOB_ID
AND PJT.JOB_ID = PJ.JOB_ID
AND PJT.LANGUAGE = USERENV('LANG')
Columns
Name |
OCCUPATION_ID |
BUSINESS_GROUP_ID |
RATE_ID |
JOB_ID |
NAME |
DATE_FROM |
DATE_TO |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
CREATED_BY |
CREATION_DATE |
OBJECT_VERSION_NUMBER |