VIEW: APPS.PAY_EMP_STATE_TAX_V1

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'