VIEW: APPS.PAYBV_US_STATE_TAX_INFO_F_V

Source

View Text - Preformatted

SELECT PUSTI.STATE_CODE ,PUSTI.EFFECTIVE_START_DATE ,PUSTI.EFFECTIVE_END_DATE ,PUSTI.SUI_EE_WAGE_LIMIT ,PUSTI.SUI_ER_WAGE_LIMIT ,PUSTI.SDI_EE_WAGE_LIMIT ,PUSTI.SDI_ER_WAGE_LIMIT ,PUSTI.SHI_EE_WAGE_LIMIT ,PUSTI.SHI_ER_WAGE_LIMIT ,PUSTI.PROGRAM_UPDATE_DATE /* codes */ ,PUSTI.SIT_EXISTS ,HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PUSTI.SIT_EXISTS) ,'_DF:PAY:STATE_TAX_INFO_LIMIT_RATES:PUSTI' /* id columns */ ,PUSTI.STATE_TAX_INFO_ID ,PUSTI.REQUEST_ID ,PUSTI.PROGRAM_APPLICATION_ID ,PUSTI.PROGRAM_ID /* who columns */ ,PUSTI.LAST_UPDATE_DATE ,PUSTI.LAST_UPDATED_BY ,PUSTI.CREATED_BY ,PUSTI.CREATION_DATE FROM PAY_US_STATE_TAX_INFO_F PUSTI WITH READ ONLY

View Text - HTML Formatted

SELECT PUSTI.STATE_CODE
, PUSTI.EFFECTIVE_START_DATE
, PUSTI.EFFECTIVE_END_DATE
, PUSTI.SUI_EE_WAGE_LIMIT
, PUSTI.SUI_ER_WAGE_LIMIT
, PUSTI.SDI_EE_WAGE_LIMIT
, PUSTI.SDI_ER_WAGE_LIMIT
, PUSTI.SHI_EE_WAGE_LIMIT
, PUSTI.SHI_ER_WAGE_LIMIT
, PUSTI.PROGRAM_UPDATE_DATE /* CODES */
, PUSTI.SIT_EXISTS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUSTI.SIT_EXISTS)
, '_DF:PAY:STATE_TAX_INFO_LIMIT_RATES:PUSTI' /* ID COLUMNS */
, PUSTI.STATE_TAX_INFO_ID
, PUSTI.REQUEST_ID
, PUSTI.PROGRAM_APPLICATION_ID
, PUSTI.PROGRAM_ID /* WHO COLUMNS */
, PUSTI.LAST_UPDATE_DATE
, PUSTI.LAST_UPDATED_BY
, PUSTI.CREATED_BY
, PUSTI.CREATION_DATE
FROM PAY_US_STATE_TAX_INFO_F PUSTI WITH READ ONLY