View: PAY_US_EMP_CITY_TAX_RULES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_US_EMP_CITY_TAX_RULES_V

View Text

SELECT CTR.ROWID
, CTR.EMP_CITY_TAX_RULE_ID
, CTR.EFFECTIVE_START_DATE
, CTR.EFFECTIVE_END_DATE
, DECODE(CTR.EFFECTIVE_END_DATE
, TO_DATE('31124712'
, 'DDMMYYYY')
, NULL
, CTR.EFFECTIVE_END_DATE) DISP_EFFECTIVE_END_DATE
, CTR.ASSIGNMENT_ID
, CTR.STATE_CODE
, PUS.STATE_NAME
, CTR.COUNTY_CODE
, PUCNTY.COUNTY_NAME
, CTR.CITY_CODE
, PUCITY.CITY_NAME
, CTR.BUSINESS_GROUP_ID
, CTR.ADDITIONAL_WA_RATE
, CTR.FILING_STATUS_CODE
, HRL.MEANING
, CTR.JURISDICTION_CODE
, CTR.LIT_ADDITIONAL_TAX
, CTR.LIT_OVERRIDE_AMOUNT
, CTR.LIT_OVERRIDE_RATE
, CTR.WITHHOLDING_ALLOWANCES
, CTR.LIT_EXEMPT
, CTR.SD_EXEMPT
, CTR.HT_EXEMPT
, CTR.WAGE_EXEMPT
, CTR.SCHOOL_DISTRICT_CODE
, PSD.SCHOOL_DST_NAME
, CTR.LAST_UPDATE_DATE
, CTR.LAST_UPDATED_BY
, CTR.LAST_UPDATE_LOGIN
, CTR.CREATED_BY
, CTR.CREATION_DATE
, CTR.OBJECT_VERSION_NUMBER
, CTR.ATTRIBUTE_CATEGORY
, CTR.ATTRIBUTE1
, CTR.ATTRIBUTE2
, CTR.ATTRIBUTE3
, CTR.ATTRIBUTE4
, CTR.ATTRIBUTE5
, CTR.ATTRIBUTE6
, CTR.ATTRIBUTE7
, CTR.ATTRIBUTE8
, CTR.ATTRIBUTE9
, CTR.ATTRIBUTE10
, CTR.ATTRIBUTE11
, CTR.ATTRIBUTE12
, CTR.ATTRIBUTE13
, CTR.ATTRIBUTE14
, CTR.ATTRIBUTE15
, CTR.ATTRIBUTE16
, CTR.ATTRIBUTE17
, CTR.ATTRIBUTE18
, CTR.ATTRIBUTE19
, CTR.ATTRIBUTE20
, CTR.ATTRIBUTE21
, CTR.ATTRIBUTE22
, CTR.ATTRIBUTE23
, CTR.ATTRIBUTE24
, CTR.ATTRIBUTE25
, CTR.ATTRIBUTE26
, CTR.ATTRIBUTE27
, CTR.ATTRIBUTE28
, CTR.ATTRIBUTE29
, CTR.ATTRIBUTE30
, CTR.CTY_INFORMATION_CATEGORY
, CTR.CTY_INFORMATION1
, CTR.CTY_INFORMATION2
, CTR.CTY_INFORMATION3
, CTR.CTY_INFORMATION4
, CTR.CTY_INFORMATION5
, CTR.CTY_INFORMATION6
, CTR.CTY_INFORMATION7
, CTR.CTY_INFORMATION8
, CTR.CTY_INFORMATION9
, CTR.CTY_INFORMATION10
, CTR.CTY_INFORMATION11
, CTR.CTY_INFORMATION12
, CTR.CTY_INFORMATION13
, CTR.CTY_INFORMATION14
, CTR.CTY_INFORMATION15
, CTR.CTY_INFORMATION16
, CTR.CTY_INFORMATION17
, CTR.CTY_INFORMATION18
, CTR.CTY_INFORMATION19
, CTR.CTY_INFORMATION20
, CTR.CTY_INFORMATION21
, CTR.CTY_INFORMATION22
, CTR.CTY_INFORMATION23
, CTR.CTY_INFORMATION24
, CTR.CTY_INFORMATION25
, CTR.CTY_INFORMATION26
, CTR.CTY_INFORMATION27
, CTR.CTY_INFORMATION28
, CTR.CTY_INFORMATION29
, CTR.CTY_INFORMATION30
FROM PAY_US_EMP_CITY_TAX_RULES_F CTR
, PAY_US_STATES PUS
, PAY_US_COUNTIES PUCNTY
, PAY_US_CITY_NAMES PUCITY
, HR_LOOKUPS HRL
, PAY_US_CITY_SCHOOL_DSTS PSD
WHERE CTR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CTR. EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID'))
AND CTR.STATE_CODE = PUS.STATE_CODE
AND CTR.STATE_CODE = PUCNTY.STATE_CODE
AND CTR.COUNTY_CODE = PUCNTY.COUNTY_CODE
AND CTR.STATE_CODE = PUCITY.STATE_CODE
AND CTR.COUNTY_CODE = PUCITY.COUNTY_CODE
AND CTR.CITY_CODE = PUCITY.CITY_CODE
AND ( PUCITY.PRIMARY_FLAG = 'Y' OR SUBSTR(PUCITY.CITY_CODE
, 1
, 1) = 'U')
AND CTR.FILING_STATUS_CODE = HRL.LOOKUP_CODE
AND HRL.LOOKUP_TYPE = 'US_LIT_FILING_STATUS'
AND CTR.STATE_CODE = PSD.STATE_CODE(+)
AND CTR.COUNTY_CODE = PSD.COUNTY_CODE(+)
AND CTR.CITY_CODE = PSD.CITY_CODE(+)
AND CTR.SCHOOL_DISTRICT_CODE = PSD.SCHOOL_DST_CODE(+)

Columns