View: HR_DE_TAX_EXEMPTIONS_V

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

View Text

SELECT PEE.ROWID ROW_ID
, PEE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ELEMENT_ENTRY_ID
, SUBSTR(ENTRY_INFORMATION1
, 1
, 30) FORM_NUMBER
, SUBSTR(ENTRY_INFORMATION2
, 1
, 30) ISSUE_DATE
, FND_DATE.CANONICAL_TO_DATE(ENTRY_INFORMATION3) VALID_FROM
, FND_DATE.CANONICAL_TO_DATE(ENTRY_INFORMATION4) VALID_TO
, SUBSTR(ENTRY_INFORMATION5
, 1
, 30) TAX_FREE_REMUNERATION
, ASSIGNMENT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
FROM PAY_ELEMENT_ENTRIES_F PEE
, FND_SESSIONS SES
WHERE ENTRY_INFORMATION_CATEGORY = 'DE_TAX EXEMPTIONS'
AND ENTRY_TYPE = 'E'
AND USERENV ('SESSIONID') = SES.SESSION_ID
AND TO_DATE(TO_CHAR(PEE.EFFECTIVE_START_DATE
, 'YYYY/MM/DD')
, 'YYYY/MM/DD') >= TO_DATE(TO_CHAR (SES.EFFECTIVE_DATE
, 'YYYY') || '/01/01'
, 'YYYY/MM/DD')
AND TO_DATE(TO_CHAR(PEE.EFFECTIVE_END_DATE
, 'YYYY/MM/DD')
, 'YYYY/MM/DD') <= TO_DATE(TO_CHAR(SES.EFFECTIVE_DATE
, 'YYYY') || '/12/31'
, 'YYYY/MM/DD')

Columns