View: HR_DE_TAX_INFORMATION_V

Product:	PER - Human Resources
Description:	View for german Tax information in the form of Elements
Implementation/DBA Data:	APPS.HR_DE_TAX_INFORMATION_V

View Text

SELECT PEE.ROWID ROW_ID
, PEE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ELEMENT_ENTRY_ID
, SUBSTR(ENTRY_INFORMATION1
, 1
, 30) TAX_CARD_NUMBER
, SUBSTR(ENTRY_INFORMATION2
, 1
, 30) TAX_YEAR
, FND_DATE.CANONICAL_TO_DATE(ENTRY_INFORMATION3) ISSUE_DATE
, SUBSTR(ENTRY_INFORMATION4
, 1
, 150) CARD_ISSUER
, SUBSTR(HR_DE_GENERAL.GET_TAX_OFFICE_DETAILS(TO_NUMBER(ENTRY_INFORMATION20))
, 1
, 4)
, SUBSTR(HR_DE_GENERAL.GET_TAX_OFFICE_DETAILS(TO_NUMBER(ENTRY_INFORMATION20))
, 5
, 240)
, TO_NUMBER(ENTRY_INFORMATION20)
, SUBSTR(ENTRY_INFORMATION7
, 1
, 150) TAX_CARD_LOCATION
, SUBSTR(ENTRY_INFORMATION8
, 1
, 30) TAX_STATUS_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_TAX_STATUS'
, ENTRY_INFORMATION8)
, 1
, 30) TAX_STATUS
, SUBSTR(ENTRY_INFORMATION9
, 1
, 30) TAX_TABLE_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_TAX_TABLE'
, ENTRY_INFORMATION9)
, 1
, 30) TAX_TABLE
, SUBSTR(ENTRY_INFORMATION10
, 1
, 30) TAX_CLASS_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_TAX_CLASS'
, ENTRY_INFORMATION10)
, 1
, 80) TAX_CLASS
, SUBSTR(ENTRY_INFORMATION24
, 1
, 30) YEARLY_CHURCH_TAX_FLAG_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ENTRY_INFORMATION24)
, 1
, 30) YEARLY_CHURCH_TAX_FLAG
, SUBSTR(ENTRY_INFORMATION25
, 1
, 30) MAX_CHURCH_TAX_FLAG_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ENTRY_INFORMATION25)
, 1
, 30) MAX_CHURCH_TAX_FLAG
, SUBSTR(ENTRY_INFORMATION15
, 1
, 30) YEARLY_INCOME_TAX_FLAG_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ENTRY_INFORMATION15)
, 1
, 30) YEARLY_INCOME_TAX_CALC_FLAG
, SUBSTR(ENTRY_INFORMATION16
, 1
, 30) CHAMBER_CONTRIBUTION_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ENTRY_INFORMATION16)
, 1
, 30) CHAMBER_CONTRIBUTION
, SUBSTR(ENTRY_INFORMATION17
, 1
, 30) PENSIONERS_TAX_FLAG_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ENTRY_INFORMATION17)
, 1
, 30) PENSIONERS_TAX_FLAG
, SUBSTR(ENTRY_INFORMATION11
, 1
, 30) NO_OF_CHILDREN
, TO_NUMBER(ENTRY_INFORMATION12) YEARLY_TAX_FREE_INCOME
, TO_NUMBER(ENTRY_INFORMATION13) MONTHLY_TAX_FREE_INCOME
, TO_NUMBER(ENTRY_INFORMATION14) ADDITIONAL_YEAR_TAXABLE_INCOME
, TO_NUMBER(ENTRY_INFORMATION18) ADDITIONAL_MTH_TAXABLE_INCOME
, SUBSTR(ENTRY_INFORMATION19
, 1
, 30) EMPLOYEE_CHURCH_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_CHURCH'
, ENTRY_INFORMATION19)
, 1
, 80) EMPLOYEE_CHURCH_NAME
, SUBSTR(ENTRY_INFORMATION21
, 1
, 30) SPOUSE_CHURCH_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_CHURCH'
, ENTRY_INFORMATION21)
, 1
, 80) SPOUSE_CHURCH_NAME
, SUBSTR(ENTRY_INFORMATION23
, 1
, 30) BUNDESLAND_CHURCH_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_FED_STATE'
, ENTRY_INFORMATION23)
, 1
, 80) BUNDESLAND_CHURCH
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEE.ASSIGNMENT_ID
, ENTRY_INFORMATION26
, DECODE(SUBSTR(ENTRY_INFORMATION26
, 1
, 1)
, 'U'
, 'USER'
, 'BATCH') UPDATED_BY
, HR_DE_GENERAL.MAX_TAX_INFO_DATE(ELEMENT_ENTRY_ID) UPDATED_DATE
FROM PAY_ELEMENT_ENTRIES_F PEE
, FND_SESSIONS SES
WHERE ENTRY_INFORMATION_CATEGORY = 'DE_TAX INFORMATION'
AND SES.SESSION_ID = USERENV('SESSIONID')
AND ENTRY_TYPE = 'E'
AND SES.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE

Columns