[Home] [Help]
View: PAY_JOB_WC_CODE_USAGES_V
View Text
SELECT JCU.ROWID
, JCU.STATE_CODE
, JCU.BUSINESS_GROUP_ID
, JCU.JOB_ID
, JCU.WC_CODE
, JBT.NAME
FROM PER_JOBS_TL JBT
, PAY_JOB_WC_CODE_USAGES JCU
WHERE JBT.JOB_ID = JCU.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
STATE_CODE |
BUSINESS_GROUP_ID |
JOB_ID |
WC_CODE |
JOB_NAME |