VIEW: APPS.PAY_EMP_FED_TAX_V1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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