Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_US_EMP_FED_TAX_RULES_V |
SELECT FTR.ROWID
, FTR. EMP_FED_TAX_RULE_ID
, FTR.EFFECTIVE_START_DATE
, FTR.EFFECTIVE_END_DATE
, DECODE(FTR.EFFECTIVE_END_DATE
, TO_DATE('31124712'
, 'DDMMYYYY')
, NULL
, FTR.EFFECTIVE_END_DATE)DISP_EFFECTIVE_END_DATE
, FTR.ASSIGNMENT_ID
, FTR.SUI_STATE_CODE
, PUS.STATE_ABBREV
, PUS.STATE_NAME
, FTR.SUI_JURISDICTION_CODE
, FTR.BUSINESS_GROUP_ID
, FTR.ADDITIONAL_WA_AMOUNT
, FTR.FILING_STATUS_CODE
, HRL1.MEANING
, FTR.FIT_OVERRIDE_AMOUNT
, FTR.FIT_OVERRIDE_RATE
, FTR.WITHHOLDING_ALLOWANCES
, FTR. CUMULATIVE_TAXATION
, FTR.EIC_FILING_STATUS_CODE
, HRL2.MEANING
, FTR. FIT_ADDITIONAL_TAX
, FTR.FIT_EXEMPT
, FTR.FUTA_TAX_EXEMPT
, FTR.MEDICARE_TAX_EXEMPT
, FTR. SS_TAX_EXEMPT
, FTR.WAGE_EXEMPT
, FTR.STATUTORY_EMPLOYEE
, FTR. W2_FILED_YEAR
, FTR. SUPP_TAX_OVERRIDE_RATE
, FTR.EXCESSIVE_WA_REJECT_DATE
, FTR. LAST_UPDATE_DATE
, FTR.LAST_UPDATED_BY
, FTR.LAST_UPDATE_LOGIN
, FTR.CREATED_BY
, FTR.CREATION_DATE
, FTR.OBJECT_VERSION_NUMBER
, FTR.ATTRIBUTE_CATEGORY
, FTR.ATTRIBUTE1
, FTR.ATTRIBUTE2
, FTR.ATTRIBUTE3
, FTR.ATTRIBUTE4
, FTR.ATTRIBUTE5
, FTR.ATTRIBUTE6
, FTR.ATTRIBUTE7
, FTR.ATTRIBUTE8
, FTR.ATTRIBUTE9
, FTR.ATTRIBUTE10
, FTR.ATTRIBUTE11
, FTR.ATTRIBUTE12
, FTR.ATTRIBUTE13
, FTR.ATTRIBUTE14
, FTR.ATTRIBUTE15
, FTR.ATTRIBUTE16
, FTR.ATTRIBUTE17
, FTR.ATTRIBUTE18
, FTR.ATTRIBUTE19
, FTR.ATTRIBUTE20
, FTR.ATTRIBUTE21
, FTR.ATTRIBUTE22
, FTR.ATTRIBUTE23
, FTR.ATTRIBUTE24
, FTR.ATTRIBUTE25
, FTR.ATTRIBUTE26
, FTR.ATTRIBUTE27
, FTR.ATTRIBUTE28
, FTR.ATTRIBUTE29
, FTR.ATTRIBUTE30
, FTR.FED_INFORMATION_CATEGORY
, FTR.FED_INFORMATION1
, FTR.FED_INFORMATION2
, FTR.FED_INFORMATION3
, FTR.FED_INFORMATION4
, FTR.FED_INFORMATION5
, FTR.FED_INFORMATION6
, FTR.FED_INFORMATION7
, FTR.FED_INFORMATION8
, FTR.FED_INFORMATION9
, FTR.FED_INFORMATION10
, FTR.FED_INFORMATION11
, FTR.FED_INFORMATION12
, FTR.FED_INFORMATION13
, FTR.FED_INFORMATION14
, FTR.FED_INFORMATION15
, FTR.FED_INFORMATION16
, FTR.FED_INFORMATION17
, FTR.FED_INFORMATION18
, FTR.FED_INFORMATION19
, FTR.FED_INFORMATION20
, FTR.FED_INFORMATION21
, FTR.FED_INFORMATION22
, FTR.FED_INFORMATION23
, FTR.FED_INFORMATION24
, FTR.FED_INFORMATION25
, FTR.FED_INFORMATION26
, FTR.FED_INFORMATION27
, FTR.FED_INFORMATION28
, FTR.FED_INFORMATION29
, FTR.FED_INFORMATION30
FROM PAY_US_EMP_FED_TAX_RULES_F FTR
, PAY_US_STATES PUS
, HR_LOOKUPS HRL1
, HR_LOOKUPS HRL2
WHERE FTR. EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND FTR.EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID'))
AND FTR.SUI_STATE_CODE = PUS.STATE_CODE
AND FTR.FILING_STATUS_CODE = HRL1.LOOKUP_CODE
AND HRL1.LOOKUP_TYPE = 'US_FIT_FILING_STATUS'
AND FTR.EIC_FILING_STATUS_CODE = HRL2.LOOKUP_CODE
AND HRL2.LOOKUP_TYPE = 'US_EIC_FILING_STATUS'