SELECT EMP_STATE_TAX_RULE_ID , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , ASSIGNMENT_ID , STATE_CODE ,JURISDICTION_CODE , BUSINESS_GROUP_ID , ADDITIONAL_WA_AMOUNT , FILING_STATUS_CODE , REMAINDER_PERCENT , SECONDARY_WA , SIT_ADDITIONAL_TAX , SIT_OVERRIDE_AMOUNT , SIT_OVERRIDE_RATE , WITHHOLDING_ALLOWANCES , EXCESSIVE_WA_REJECT_DATE , SDI_EXEMPT , SIT_EXEMPT , SIT_OPTIONAL_CALC_IND , STATE_NON_RESIDENT_CERT , SUI_EXEMPT ,WC_EXEMPT ,WAGE_EXEMPT ,SUI_WAGE_BASE_OVERRIDE_AMOUNT ,SUPP_TAX_OVERRIDE_RATE , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATED_BY , CREATION_DATE ,OBJECT_VERSION_NUMBER ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,ATTRIBUTE21 ,ATTRIBUTE22 ,ATTRIBUTE23 ,ATTRIBUTE24 ,ATTRIBUTE25 ,ATTRIBUTE26 ,ATTRIBUTE27 ,ATTRIBUTE28 ,ATTRIBUTE29 ,ATTRIBUTE30 ,STA_INFORMATION_CATEGORY ,STA_INFORMATION1 ,STA_INFORMATION2 ,STA_INFORMATION3 ,STA_INFORMATION4 ,STA_INFORMATION5 ,STA_INFORMATION6 ,STA_INFORMATION7 ,STA_INFORMATION8 ,STA_INFORMATION9 ,STA_INFORMATION10 ,STA_INFORMATION11 ,STA_INFORMATION12 ,STA_INFORMATION13 ,STA_INFORMATION14 ,STA_INFORMATION15 ,STA_INFORMATION16 ,STA_INFORMATION17 ,STA_INFORMATION18 ,STA_INFORMATION19 ,STA_INFORMATION20 ,STA_INFORMATION21 ,STA_INFORMATION22 ,STA_INFORMATION23 ,STA_INFORMATION24 ,STA_INFORMATION25 ,STA_INFORMATION26 ,STA_INFORMATION27 ,STA_INFORMATION28 ,STA_INFORMATION29 ,STA_INFORMATION30 FROM PAY_US_EMP_STATE_TAX_RULES_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
SELECT EMP_STATE_TAX_RULE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ASSIGNMENT_ID
, STATE_CODE
, JURISDICTION_CODE
, BUSINESS_GROUP_ID
, ADDITIONAL_WA_AMOUNT
, FILING_STATUS_CODE
, REMAINDER_PERCENT
, SECONDARY_WA
, SIT_ADDITIONAL_TAX
, SIT_OVERRIDE_AMOUNT
, SIT_OVERRIDE_RATE
, WITHHOLDING_ALLOWANCES
, EXCESSIVE_WA_REJECT_DATE
, SDI_EXEMPT
, SIT_EXEMPT
, SIT_OPTIONAL_CALC_IND
, STATE_NON_RESIDENT_CERT
, SUI_EXEMPT
, WC_EXEMPT
, WAGE_EXEMPT
, SUI_WAGE_BASE_OVERRIDE_AMOUNT
, SUPP_TAX_OVERRIDE_RATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, STA_INFORMATION_CATEGORY
, STA_INFORMATION1
, STA_INFORMATION2
, STA_INFORMATION3
, STA_INFORMATION4
, STA_INFORMATION5
, STA_INFORMATION6
, STA_INFORMATION7
, STA_INFORMATION8
, STA_INFORMATION9
, STA_INFORMATION10
, STA_INFORMATION11
, STA_INFORMATION12
, STA_INFORMATION13
, STA_INFORMATION14
, STA_INFORMATION15
, STA_INFORMATION16
, STA_INFORMATION17
, STA_INFORMATION18
, STA_INFORMATION19
, STA_INFORMATION20
, STA_INFORMATION21
, STA_INFORMATION22
, STA_INFORMATION23
, STA_INFORMATION24
, STA_INFORMATION25
, STA_INFORMATION26
, STA_INFORMATION27
, STA_INFORMATION28
, STA_INFORMATION29
, STA_INFORMATION30
FROM PAY_US_EMP_STATE_TAX_RULES_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
|
|
|