Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_US_EMP_COUNTY_TAX_RULES_V |
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(+)