View: PAY_US_STATE_TAX_TYPES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_US_STATE_TAX_TYPES_V

View Text

SELECT PUTT.TAX_TYPE_ID
, PUTT.LIMIT_TAX_FLAG
, PUTT.TAX_DOMAIN_CODE
, PUTT.TAX_TYPE_CODE
, PUTB.BALANCE_CATEGORY_CODE
, PUTB.EE_OR_ER_CODE
, PUTB.USER_REPORTING_NAME
, PETTL.ELEMENT_NAME
, PET.ELEMENT_TYPE_ID
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.BUSINESS_GROUP_ID
, PET.PROCESSING_PRIORITY
, PET.LEGISLATION_CODE
FROM PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_US_TAX_TYPES PUTT
, PAY_US_TAX_BALANCES PUTB
WHERE PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PUTT.TAX_TYPE_ID = PUTB.TAX_TYPE_ID
AND PUTT.TAX_DOMAIN_CODE = 'STATE'
AND PUTB.BALANCE_CATEGORY_CODE IN ( 'WITHHELD'
, 'ADVANCED')
AND PUTB.EE_OR_ER_CODE = 'EE'
AND PET.ELEMENT_NAME IN ('SIT_WK'
, 'SDI_EE'
, 'SUI_EE'
, 'STEIC_WK'
, 'WORKERS COMPENSATION'
, 'WORKERS COMPENSATION2 EE')
AND PUTT.TAX_TYPE_CODE = DECODE(PET.ELEMENT_NAME
, 'WORKERS COMPENSATION'
, 'WC'
, 'WORKERS COMPENSATION2 EE'
, 'WC2'
, 'STEIC_WK'
, 'STEIC'
, SUBSTR(PET.ELEMENT_NAME
, 1
, 3))

Columns