View: PAY_KR_NP_PREM_V

Product:	PAY - Payroll
Description:	This view returns entry value of 'National Pension Prem' element based on assignment_id and session_date.
Implementation/DBA Data:	APPS.PAY_KR_NP_PREM_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
, 1
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE1
, 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 = 'NP_PREM'
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