VIEW: APPS.PAY_EMP_LOCAL_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, 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'

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
, 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'