View: PAY_PAYWSMEE_OVERRIDES

Product:	PAY - Payroll
Description:	List of element entries that override other element entries within a payroll period.
Implementation/DBA Data:	APPS.PAY_PAYWSMEE_OVERRIDES

View Text

SELECT ENTRY.TARGET_ENTRY_ID
, ENTRY.ELEMENT_ENTRY_ID
, ENTRY.EFFECTIVE_START_DATE
, ENTRY.EFFECTIVE_END_DATE
, ENTRY.ASSIGNMENT_ID
, ENTRY.ELEMENT_LINK_ID
, ENTRY.CREATOR_TYPE
, VALUE.ELEMENT_ENTRY_VALUE_ID
, VALUE.INPUT_VALUE_ID
, DECODE (INPVAL.LOOKUP_TYPE
, NULL
, DECODE (INPVAL.HOT_DEFAULT_FLAG
, 'N'
, HR_CHKFMT.CHANGEFORMAT (VALUE.SCREEN_ENTRY_VALUE
, INPVAL.UOM
, TYPE.INPUT_CURRENCY_CODE)
, HR_CHKFMT.CHANGEFORMAT (NVL (VALUE.SCREEN_ENTRY_VALUE
, NVL (LINKVAL.DEFAULT_VALUE
, INPVAL.DEFAULT_VALUE))
, INPVAL.UOM
, TYPE.INPUT_CURRENCY_CODE))
, HR_GENERAL.DECODE_LOOKUP (INPVAL.LOOKUP_TYPE
, DECODE (INPVAL.HOT_DEFAULT_FLAG
, 'N'
, VALUE.SCREEN_ENTRY_VALUE
, NVL (VALUE.SCREEN_ENTRY_VALUE
, NVL (LINKVAL.DEFAULT_VALUE
, INPVAL.DEFAULT_VALUE))))) OVERRIDE_VALUE
, INPVAL.DISPLAY_SEQUENCE
, INPVALTL.NAME
, INPVAL.UOM
FROM PAY_ELEMENT_ENTRIES_F ENTRY
, PAY_ELEMENT_ENTRY_VALUES_F VALUE
, PAY_LINK_INPUT_VALUES_F LINKVAL
, PAY_ELEMENT_LINKS_F LINK
, PAY_ELEMENT_TYPES_F TYPE
, PAY_INPUT_VALUES_F_TL INPVALTL
, PAY_INPUT_VALUES_F INPVAL
, FND_SESSIONS SESH
WHERE INPVAL.INPUT_VALUE_ID = INPVALTL.INPUT_VALUE_ID
AND INPVALTL.LANGUAGE = USERENV('LANG')
AND USERENV ('SESSIONID') = SESH.SESSION_ID
AND SESH.EFFECTIVE_DATE BETWEEN LINKVAL.EFFECTIVE_START_DATE
AND LINKVAL.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN TYPE.EFFECTIVE_START_DATE
AND TYPE.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN INPVAL.EFFECTIVE_START_DATE
AND INPVAL.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN ENTRY.EFFECTIVE_START_DATE
AND ENTRY.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN VALUE.EFFECTIVE_START_DATE
AND VALUE.EFFECTIVE_END_DATE
AND ENTRY.ELEMENT_ENTRY_ID = VALUE.ELEMENT_ENTRY_ID
AND TYPE.ELEMENT_TYPE_ID = LINK.ELEMENT_TYPE_ID
AND ENTRY.ELEMENT_LINK_ID = LINK.ELEMENT_LINK_ID
AND LINKVAL.INPUT_VALUE_ID = VALUE.INPUT_VALUE_ID
AND LINKVAL.ELEMENT_LINK_ID = LINK.ELEMENT_LINK_ID
AND INPVAL.INPUT_VALUE_ID = VALUE.INPUT_VALUE_ID
AND ENTRY.ENTRY_TYPE='S'

Columns