Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_EMP_LOCAL_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
, PAEI.AEI_INFORMATION2 JURISDICTION_CODE
, PAEI.AEI_INFORMATION3 FILING_STATUS_CODE
, HRL1.MEANING FILING_STATUS
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION4) WITHHOLDING_ALLOWANCES
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION5) ADDITIONAL_WA_RATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION6) LIT_ADDITIONAL_TAX
, PAEI.AEI_INFORMATION7 LIT_EXEMPT
, PAEI.AEI_INFORMATION14 SD_EXEMPT
, PAEI.AEI_INFORMATION15 HT_EXEMPT
, PAEI.AEI_INFORMATION8 ENABLED
, PAEI.AEI_INFORMATION9 SCHOOL_DISTRICT_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION10) TIME_IN_LOCALITY
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION11) LIT_OVERRIDE_RATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION12) LIT_OVERRIDE_AMOUNT
, PAEI.AEI_INFORMATION13 CITY_NAME
FROM HR_LOOKUPS HRL1
, PAY_STATE_RULES PSR
, PER_ASSIGNMENT_EXTRA_INFO PAEI
WHERE PAEI.AEI_INFORMATION3 = HRL1.LOOKUP_CODE
AND HRL1.LOOKUP_TYPE = 'US_LIT_FILING_STATUS'
AND PAEI.AEI_INFORMATION1 = PSR.STATE_CODE
AND PAEI.INFORMATION_TYPE||'' = 'LOCALITY'