Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_NONRESIDENT_ENTRIES_V |
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.NAME
, 'NRES_START_DATE'
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.NAME
, 'PROJECTED_RES_DATE'
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.NAME
, 'NRES_START_DATE'
, FND_DATE.CANONICAL_TO_DATE(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, MIN(DISTINCT DECODE(PIV.NAME
, 'PROJECTED_RES_DATE'
, FND_DATE.CANONICAL_TO_DATE(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, MIN(DISTINCT PEE.CREATION_DATE)
, MIN(DISTINCT PEE.CREATED_BY)
, MIN(DISTINCT PEE.LAST_UPDATE_DATE)
, MIN(DISTINCT PEE.LAST_UPDATED_BY)
, MIN(DISTINCT PEE.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 = 'COM_NRES_INFO'
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