VIEW: APPS.PAY_US_EMP_COUNTY_TAX_RULES_V

Source

View Text - Preformatted

SELECT CTR.ROWID ,CTR.EMP_COUNTY_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 ,PUC.COUNTY_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.CNT_INFORMATION_CATEGORY ,CTR.CNT_INFORMATION1 ,CTR.CNT_INFORMATION2 ,CTR.CNT_INFORMATION3 ,CTR.CNT_INFORMATION4 ,CTR.CNT_INFORMATION5 ,CTR.CNT_INFORMATION6 ,CTR.CNT_INFORMATION7 ,CTR.CNT_INFORMATION8 ,CTR.CNT_INFORMATION9 ,CTR.CNT_INFORMATION10 ,CTR.CNT_INFORMATION11 ,CTR.CNT_INFORMATION12 ,CTR.CNT_INFORMATION13 ,CTR.CNT_INFORMATION14 ,CTR.CNT_INFORMATION15 ,CTR.CNT_INFORMATION16 ,CTR.CNT_INFORMATION17 ,CTR.CNT_INFORMATION18 ,CTR.CNT_INFORMATION19 ,CTR.CNT_INFORMATION20 ,CTR.CNT_INFORMATION21 ,CTR.CNT_INFORMATION22 ,CTR.CNT_INFORMATION23 ,CTR.CNT_INFORMATION24 ,CTR.CNT_INFORMATION25 ,CTR.CNT_INFORMATION26 ,CTR.CNT_INFORMATION27 ,CTR.CNT_INFORMATION28 ,CTR.CNT_INFORMATION29 ,CTR.CNT_INFORMATION30 FROM PAY_US_EMP_COUNTY_TAX_RULES_F CTR, PAY_US_STATES PUS, PAY_US_COUNTIES PUC, HR_LOOKUPS HRL, PAY_US_COUNTY_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=PUC.STATE_CODE AND CTR.COUNTY_CODE = PUC.COUNTY_CODE 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.SCHOOL_DISTRICT_CODE = PSD.SCHOOL_DST_CODE(+)

View Text - HTML Formatted

SELECT CTR.ROWID
, CTR.EMP_COUNTY_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
, PUC.COUNTY_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.CNT_INFORMATION_CATEGORY
, CTR.CNT_INFORMATION1
, CTR.CNT_INFORMATION2
, CTR.CNT_INFORMATION3
, CTR.CNT_INFORMATION4
, CTR.CNT_INFORMATION5
, CTR.CNT_INFORMATION6
, CTR.CNT_INFORMATION7
, CTR.CNT_INFORMATION8
, CTR.CNT_INFORMATION9
, CTR.CNT_INFORMATION10
, CTR.CNT_INFORMATION11
, CTR.CNT_INFORMATION12
, CTR.CNT_INFORMATION13
, CTR.CNT_INFORMATION14
, CTR.CNT_INFORMATION15
, CTR.CNT_INFORMATION16
, CTR.CNT_INFORMATION17
, CTR.CNT_INFORMATION18
, CTR.CNT_INFORMATION19
, CTR.CNT_INFORMATION20
, CTR.CNT_INFORMATION21
, CTR.CNT_INFORMATION22
, CTR.CNT_INFORMATION23
, CTR.CNT_INFORMATION24
, CTR.CNT_INFORMATION25
, CTR.CNT_INFORMATION26
, CTR.CNT_INFORMATION27
, CTR.CNT_INFORMATION28
, CTR.CNT_INFORMATION29
, CTR.CNT_INFORMATION30
FROM PAY_US_EMP_COUNTY_TAX_RULES_F CTR
, PAY_US_STATES PUS
, PAY_US_COUNTIES PUC
, HR_LOOKUPS HRL
, PAY_US_COUNTY_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=PUC.STATE_CODE
AND CTR.COUNTY_CODE = PUC.COUNTY_CODE
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.SCHOOL_DISTRICT_CODE = PSD.SCHOOL_DST_CODE(+)