[Home] [Help]
View: PAY_WC_STATE_SURCHARGES_V
View Text
SELECT WSS.ROWID ROW_ID
, WSS.SURCHARGE_ID SURCHARGE_ID
, WSS.STATE_CODE STATE_CODE
, WSS.NAME NAME
, WSS.POSITION POSITION
, L2.MEANING POSITION_NAME
, WSS.RATE RATE
, WSS.ADD_TO_RT ADD_TO_RT
, L1.MEANING ADD_TO_RT_MEANING
, WSS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, WSS.LAST_UPDATED_BY LAST_UPDATED_BY
, WSS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WSS.CREATED_BY CREATED_BY
, WSS.CREATION_DATE
FROM HR_LOOKUPS L1
, HR_LOOKUPS L2
, PAY_WC_STATE_SURCHARGES WSS
WHERE L2.LOOKUP_TYPE = 'US_WC_SURCHARGE_POSITION'
AND L2.LOOKUP_CODE = WSS.POSITION
AND L1.LOOKUP_TYPE = 'YES_NO'
AND L1.LOOKUP_CODE = WSS.ADD_TO_RT
Columns
Name |
ROW_ID |
SURCHARGE_ID |
STATE_CODE |
NAME |
POSITION |
POSITION_NAME |
RATE |
ADD_TO_RT |
ADD_TO_RT_MEANING |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |