View: PAY_WC_STATE_SURCHARGES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.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