View: PAY_KR_DEPENDENT_V

Product:	PAY - Payroll
Description:	This view returns entry value of 'Depedent Tax Exemption' element based on assignment_id and session_date.
Implementation/DBA Data:	APPS.PAY_KR_DEPENDENT_V

View Text

SELECT PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEE.ASSIGNMENT_ID
, PEL.ELEMENT_LINK_ID
, PEE.OBJECT_VERSION_NUMBER
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID1
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID2
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID3
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID4
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID5
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID6
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 7
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID7
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 8
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID8
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 1) ENTRY_VALUE1
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE2
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE3
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE4
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE5
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE6
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 7
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 1) ENTRY_VALUE7
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 8
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE8
, MIN(DISTINCT PEE.CREATION_DATE) CREATION_DATE
, MIN(DISTINCT PEE.CREATED_BY) CREATED_BY
, MIN(DISTINCT PEE.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, MIN(DISTINCT PEE.LAST_UPDATED_BY) LAST_UPDATED_BY
, MIN(DISTINCT PEE.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN
FROM PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_TYPES_F PET
, FND_SESSIONS FND
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND PET.ELEMENT_NAME = 'DPNT_TAX_EXEM'
AND FND.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEE.ENTRY_TYPE = 'E'
AND FND.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PEL.ELEMENT_TYPE_ID + 0 = PET.ELEMENT_TYPE_ID
AND FND.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PEEV.ELEMENT_ENTRY_ID = NVL(PEE.ELEMENT_ENTRY_ID
, PEL.ELEMENT_LINK_ID)
AND PEEV.EFFECTIVE_START_DATE = PEE.EFFECTIVE_START_DATE
AND PEEV.EFFECTIVE_END_DATE = PEE.EFFECTIVE_END_DATE
AND PIV.INPUT_VALUE_ID = PEEV.INPUT_VALUE_ID
AND FND.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE GROUP BY PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEE.ASSIGNMENT_ID
, PEL.ELEMENT_LINK_ID
, PEE.OBJECT_VERSION_NUMBER

Columns