Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_EMP_FED_TAX_V1 |
SELECT PAEI.ROWID ROW_ID
, PAEI.ASSIGNMENT_EXTRA_INFO_ID
, PAEI.ASSIGNMENT_ID
, PAEI.INFORMATION_TYPE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION1) WITHHOLDING_ALLOWANCES
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION2) ADDITIONAL_WA_AMOUNT
, FND_DATE.CANONICAL_TO_DATE(PAEI.AEI_INFORMATION3) EXCESSIVE_WA_REJECT_DATE
, PAEI.AEI_INFORMATION4 FILING_STATUS_CODE
, HRL1.MEANING FILING_STATUS
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION5) FIT_ADDITIONAL_TAX
, PAEI.AEI_INFORMATION6 FIT_EXEMPT
, PAEI.AEI_INFORMATION7 MEDICARE_TAX_EXEMPT
, PAEI.AEI_INFORMATION8 SS_TAX_EXEMPT
, PAEI.AEI_INFORMATION9 FUTA_TAX_EXEMPT
, PAEI.AEI_INFORMATION10 STATUTORY_EMPLOYEE
, PAEI.AEI_INFORMATION11 CUMULATIVE_TAXATION
, PAEI.AEI_INFORMATION12 EIC_FILING_STATUS_CODE
, HRL2.MEANING EIC_FILING_STATUS
, PAEI.AEI_INFORMATION13 W2_FILED_YEAR
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION14) FIT_OVERRIDE_RATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION15) FIT_OVERRIDE_AMOUNT
, PAEI.AEI_INFORMATION16 RESIDENT_STATE_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAEI.AEI_INFORMATION17) SUPP_TAX_OVERRIDE_RATE
, PAEI.AEI_INFORMATION18 SUI_JURISDICTION_CODE
, PSR.STATE_CODE SUI_STATE_CODE
, PSR.NAME SUI_STATE_NAME
, PAEI.AEI_INFORMATION19 RESIDENT_LOCALITY
, PAEI.AEI_INFORMATION20 WORK_LOCALITY
FROM HR_LOOKUPS HRL1
, HR_LOOKUPS HRL2
, PAY_STATE_RULES PSR
, PER_ASSIGNMENT_EXTRA_INFO PAEI
WHERE PAEI.AEI_INFORMATION4 = HRL1.LOOKUP_CODE
AND HRL1.LOOKUP_TYPE = 'US_FIT_FILING_STATUS'
AND PAEI.AEI_INFORMATION12 = HRL2.LOOKUP_CODE
AND HRL2.LOOKUP_TYPE = 'US_EIC_FILING_STATUS'
AND PAEI.INFORMATION_TYPE||'' = 'FEDERAL'
AND PAEI.AEI_INFORMATION18 = PSR.JURISDICTION_CODE