Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_CMA_TRAIN_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.DISPLAY_SEQUENCE
, 1
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 7
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 8
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 9
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 10
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 11
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 12
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 13
, PEEV.INPUT_VALUE_ID
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 60)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 60)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 60)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 7
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 8
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 6)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 9
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 6)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 10
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 11
, FND_DATE.CANONICAL_TO_DATE(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 12
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 13
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 60)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 10
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 12
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, MIN(DISTINCT PEE.ATTRIBUTE_CATEGORY)
, MIN(DISTINCT PEE.ATTRIBUTE1)
, MIN(DISTINCT PEE.ATTRIBUTE2)
, MIN(DISTINCT PEE.ATTRIBUTE3)
, MIN(DISTINCT PEE.ATTRIBUTE4)
, MIN(DISTINCT PEE.ATTRIBUTE5)
, MIN(DISTINCT PEE.ATTRIBUTE6)
, MIN(DISTINCT PEE.ATTRIBUTE7)
, MIN(DISTINCT PEE.ATTRIBUTE8)
, MIN(DISTINCT PEE.ATTRIBUTE9)
, MIN(DISTINCT PEE.ATTRIBUTE10)
, MIN(DISTINCT PEE.ATTRIBUTE11)
, MIN(DISTINCT PEE.ATTRIBUTE12)
, MIN(DISTINCT PEE.ATTRIBUTE13)
, MIN(DISTINCT PEE.ATTRIBUTE14)
, MIN(DISTINCT PEE.ATTRIBUTE15)
, MIN(DISTINCT PEE.ATTRIBUTE16)
, MIN(DISTINCT PEE.ATTRIBUTE17)
, MIN(DISTINCT PEE.ATTRIBUTE18)
, MIN(DISTINCT PEE.ATTRIBUTE19)
, MIN(DISTINCT PEE.ATTRIBUTE20)
, 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 = 'SAL_CMA_PUBLIC_TRANSPORT_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