VIEW: APPS.PAY_US_STATE_EE_WAGE_TYPES_V

Source

View Text - Preformatted

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 ('SUBJECT', 'SUBJ_WHABLE', 'SUBJ_NWHABLE') and PUTT.limit_tax_flag = 'N') OR ( PUTB.BALANCE_CATEGORY_CODE IN ('SUBJECT', 'TAXABLE') AND PUTT.limit_tax_flag = 'Y') ) AND PUTB.EE_OR_ER_CODE = 'EE' AND PUTT.TAX_TYPE_CODE = SUBSTR(PETTL.ELEMENT_NAME, 1, 3) AND PET.ELEMENT_NAME NOT LIKE ('%_ER%') AND PET.ELEMENT_NAME NOT LIKE ('%_RS%') AND PET.ELEMENT_NAME NOT LIKE ('%ARR%') AND PET.ELEMENT_NAME NOT LIKE ('SDI_SUBJECT%') AND PET.ELEMENT_NAME NOT LIKE ('SUI_SUBJECT%') AND PET.ELEMENT_NAME NOT LIKE ('SIT_WK') AND PET.ELEMENT_NAME NOT LIKE ('SIT_WK_NON_AGGREGATE_RED_SUBJ_WHABLE')

View Text - HTML Formatted

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 ('SUBJECT'
, 'SUBJ_WHABLE'
, 'SUBJ_NWHABLE')
AND PUTT.LIMIT_TAX_FLAG = 'N') OR ( PUTB.BALANCE_CATEGORY_CODE IN ('SUBJECT'
, 'TAXABLE')
AND PUTT.LIMIT_TAX_FLAG = 'Y') )
AND PUTB.EE_OR_ER_CODE = 'EE'
AND PUTT.TAX_TYPE_CODE = SUBSTR(PETTL.ELEMENT_NAME
, 1
, 3)
AND PET.ELEMENT_NAME NOT LIKE ('%_ER%')
AND PET.ELEMENT_NAME NOT LIKE ('%_RS%')
AND PET.ELEMENT_NAME NOT LIKE ('%ARR%')
AND PET.ELEMENT_NAME NOT LIKE ('SDI_SUBJECT%')
AND PET.ELEMENT_NAME NOT LIKE ('SUI_SUBJECT%')
AND PET.ELEMENT_NAME NOT LIKE ('SIT_WK')
AND PET.ELEMENT_NAME NOT LIKE ('SIT_WK_NON_AGGREGATE_RED_SUBJ_WHABLE')