Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_STATE_TAX_INFO_F_V |
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