VIEW: APPS.PAY_WC_STATE_SURCHARGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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