View: PAY_BE_TAX_ELEMENT_ENTRIES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_BE_TAX_ELEMENT_ENTRIES_V

View Text

SELECT PEE.ROWID ROW_ID
, PEE.ELEMENT_ENTRY_ID
, MAX(PEE.OBJECT_VERSION_NUMBER) OBJECT_VERSION_NUMBER
, PEL.ELEMENT_LINK_ID
, MIN(DECODE(PIV.NAME
, 'RSZ SUBMISSION NEEDED'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID1
, MIN(DECODE(PIV.NAME
, 'RSZ SUBMISSION NEEDED'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) RSZ_SUBMISSION_REQUIRED
, MIN(DECODE(PIV.NAME
, 'RSZ CATEGORY'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID2
, MIN(DECODE(PIV.NAME
, 'RSZ CATEGORY'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) RSZ_CATEGORY
, MIN(DECODE(PIV.NAME
, 'RSZ CATEGORY'
, SUBSTR(HR_GENERAL.DECODE_LOOKUP ('BE_RSZ_CATEGORY'
, EEV.SCREEN_ENTRY_VALUE)
, 1
, 80)
, NULL)) RSZ_CATEGORY_MEANING
, MIN(DECODE(PIV.NAME
, 'AGREED TO PART TIME'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID3
, MIN(DECODE(PIV.NAME
, 'AGREED TO PART TIME'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) WORKING_PART_TIME_VOLUNTARILY
, MIN(DECODE(PIV.NAME
, 'CROSS BORDER WORKER'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID4
, MIN(DECODE(PIV.NAME
, 'CROSS BORDER WORKER'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) CROSS_BORDER_WORKER
, MIN(DECODE(PIV.NAME
, 'REDUCED CATEGORY'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID5
, MIN(DECODE(PIV.NAME
, 'REDUCED CATEGORY'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) REDUCED_CHARGES_CATEGORY
, MIN(DECODE(PIV.NAME
, 'REDUCED CATEGORY'
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('BE_REDUCED_CHARGES_CATEGORY'
, EEV.SCREEN_ENTRY_VALUE)
, 1
, 80)
, NULL)) REDUCED_CHARGES_CAT_MEANING
, MIN(DECODE(PIV.NAME
, 'REDUCED CATEGORY START'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID6
, MIN(DECODE(PIV.NAME
, 'REDUCED CATEGORY START'
, FND_DATE.CANONICAL_TO_DATE(EEV.SCREEN_ENTRY_VALUE)
, NULL)) REDUCED_CHARGES_START_DATE
, MIN(DECODE(PIV.NAME
, 'REDUCED CATEGORY END'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID7
, MIN(DECODE(PIV.NAME
, 'REDUCED CATEGORY END'
, FND_DATE.CANONICAL_TO_DATE( EEV.SCREEN_ENTRY_VALUE)
, NULL)) REDUCED_CHARGES_END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEE.ASSIGNMENT_ID
FROM PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_ENTRY_VALUES_F EEV
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F PET
, FND_SESSIONS SES
WHERE SES.SESSION_ID = USERENV('SESSIONID')
AND PEE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_ID
AND SES.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV.INPUT_VALUE_ID + 0 = PIV.INPUT_VALUE_ID
AND SES.EFFECTIVE_DATE BETWEEN EEV.EFFECTIVE_START_DATE
AND EEV.EFFECTIVE_END_DATE
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND SES.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND SES.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PET.ELEMENT_NAME = 'TAX INFORMATION'
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE GROUP BY PEE.ROWID
, PEE.ELEMENT_ENTRY_ID
, PEL.ELEMENT_LINK_ID
, PEE.ASSIGNMENT_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE

Columns