VIEW: APPS.HR_DE_TAX_EXEMPTIONS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')