Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_EMP_STATE_TAX_V1 |
SELECT PAEI.ROWID ROW_ID
, PAEI.ASSIGNMENT_EXTRA_INFO_ID
, PAEI.ASSIGNMENT_ID
, PAEI.INFORMATION_TYPE
, PAEI.AEI_INFORMATION1 STATE_CODE
, PSR.NAME STATE_NAME
, PSR.JURISDICTION_CODE
, PAEI.AEI_INFORMATION2 FILING_STATUS_CODE
, HRL1.MEANING FILING_STATUS
, PAEI.AEI_INFORMATION3 STATE_NON_RESIDENT_CERT
, PAEI.AEI_INFORMATION4 SIT_EXEMPT
, PAEI.AEI_INFORMATION5 SDI_EXEMPT
, PAEI.AEI_INFORMATION6 SUI_EXEMPT
, PAEI.AEI_INFORMATION19 WC_EXEMPT
, PAEI.AEI_INFORMATION7 ENABLED
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION8) SIT_ADDITIONAL_TAX
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION9) SECONDARY_WA
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION10) WITHHOLDING_ALLOWANCES
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION11) ADDITIONAL_WA_AMOUNT
, PAEI.AEI_INFORMATION12 SIT_OPTIONAL_CALC_IND
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION13) TIME_IN_STATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION14) SIT_OVERRIDE_RATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION15) SIT_OVERRIDE_AMOUNT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION16) REMAINDER_PERCENT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION18) SUPP_TAX_OVERRIDE_RATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION20) SUI_WAGE_BASE_OVERRIDE_AMOUNT
, FND_DATE.CANONICAL_TO_DATE(PAEI.AEI_INFORMATION17) EXCESSIVE_WA_REJECT_DATE
FROM HR_LOOKUPS HRL1
, PAY_STATE_RULES PSR
, PER_ASSIGNMENT_EXTRA_INFO PAEI
WHERE PAEI.AEI_INFORMATION2 = HRL1.LOOKUP_CODE
AND HRL1.LOOKUP_TYPE = PSR.FS_LOOKUP_TYPE
AND PSR.STATE_CODE = PAEI.AEI_INFORMATION1
AND PAEI.INFORMATION_TYPE||'' = 'STATE'