View: PAY_JP_WP_COMP_ENTRIES_V

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_WP_COMP_ENTRIES_V

View Text

SELECT /*+ ORDERED INDEX(FND FND_SESSIONS_U1) INDEX(PET PAY_ELEMENT_TYPES_F_UK2) INDEX(PEE PAY_ELEMENT_ENTRIES_F_N50) INDEX(PEL PAY_ELEMENT_LINKS_F_PK) INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) INDEX(PIV PAY_INPUT_VALUES_F_PK) */ 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))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 6)
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, 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 FND_SESSIONS FND
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_INPUT_VALUES_F PIV
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND PET.ELEMENT_NAME = 'COM_WP_SMR_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

Columns