VIEW: APPS.PAY_PAYWSMEE_OVERRIDES

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'