VIEW: APPS.PAY_PAYWSMEE_ADJUSTMENT

Source

View Text - Preformatted

SELECT ENTRY.ELEMENT_ENTRY_ID , ENTRY.EFFECTIVE_START_DATE , ENTRY.EFFECTIVE_END_DATE , ENTRY.TARGET_ENTRY_ID , ENTRY.ENTRY_TYPE , ENTRY.ASSIGNMENT_ID , ENTRY.ELEMENT_LINK_ID , VALUE.INPUT_VALUE_ID , VALUE.SCREEN_ENTRY_VALUE , DECODE (ENTRY.ENTRY_TYPE, 'R',HR_CHKFMT.CHANGEFORMAT (VALUE.SCREEN_ENTRY_VALUE, INPVAL.UOM, TYPE.INPUT_CURRENCY_CODE), HR_CHKFMT.CHANGEFORMAT (TRANSLATE (VALUE.SCREEN_ENTRY_VALUE, 'x-', 'x'), INPVAL.UOM, TYPE.INPUT_CURRENCY_CODE)) ENTRY_VALUE , DECODE (ENTRY.ENTRY_TYPE, 'A', DECODE (SIGN (VALUE.SCREEN_ENTRY_VALUE), -1, 'SUBTRACT', 'ADD'), 'REPLACE') ADJUSTMENT_TYPE FROM PAY_INPUT_VALUES_F INPVAL, PAY_ELEMENT_TYPES_F TYPE, PAY_ELEMENT_LINKS_F LINK, PAY_ELEMENT_ENTRY_VALUES_F VALUE, PAY_ELEMENT_ENTRIES_F ENTRY, FND_SESSIONS SESH WHERE SESH.SESSION_ID = USERENV ('sessionid') AND SESH.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE AND LINK.EFFECTIVE_END_DATE AND TYPE.ELEMENT_TYPE_ID = LINK.ELEMENT_TYPE_ID AND SESH.EFFECTIVE_DATE BETWEEN TYPE.EFFECTIVE_START_DATE AND TYPE.EFFECTIVE_END_DATE AND ENTRY.ELEMENT_LINK_ID = LINK.ELEMENT_LINK_ID AND SESH.EFFECTIVE_DATE BETWEEN ENTRY.EFFECTIVE_START_DATE AND ENTRY.EFFECTIVE_END_DATE AND ENTRY.ENTRY_TYPE IN ('A', 'R') AND VALUE.ELEMENT_ENTRY_ID = ENTRY.ELEMENT_ENTRY_ID AND VALUE.EFFECTIVE_START_DATE = ENTRY.EFFECTIVE_START_DATE AND VALUE.EFFECTIVE_END_DATE = ENTRY.EFFECTIVE_END_DATE AND INPVAL.INPUT_VALUE_ID = VALUE.INPUT_VALUE_ID AND UPPER (INPVAL.NAME) = UPPER ('PAY VALUE') AND SESH.EFFECTIVE_DATE BETWEEN INPVAL.EFFECTIVE_START_DATE AND INPVAL.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ENTRY.ELEMENT_ENTRY_ID
, ENTRY.EFFECTIVE_START_DATE
, ENTRY.EFFECTIVE_END_DATE
, ENTRY.TARGET_ENTRY_ID
, ENTRY.ENTRY_TYPE
, ENTRY.ASSIGNMENT_ID
, ENTRY.ELEMENT_LINK_ID
, VALUE.INPUT_VALUE_ID
, VALUE.SCREEN_ENTRY_VALUE
, DECODE (ENTRY.ENTRY_TYPE
, 'R'
, HR_CHKFMT.CHANGEFORMAT (VALUE.SCREEN_ENTRY_VALUE
, INPVAL.UOM
, TYPE.INPUT_CURRENCY_CODE)
, HR_CHKFMT.CHANGEFORMAT (TRANSLATE (VALUE.SCREEN_ENTRY_VALUE
, 'X-'
, 'X')
, INPVAL.UOM
, TYPE.INPUT_CURRENCY_CODE)) ENTRY_VALUE
, DECODE (ENTRY.ENTRY_TYPE
, 'A'
, DECODE (SIGN (VALUE.SCREEN_ENTRY_VALUE)
, -1
, 'SUBTRACT'
, 'ADD')
, 'REPLACE') ADJUSTMENT_TYPE
FROM PAY_INPUT_VALUES_F INPVAL
, PAY_ELEMENT_TYPES_F TYPE
, PAY_ELEMENT_LINKS_F LINK
, PAY_ELEMENT_ENTRY_VALUES_F VALUE
, PAY_ELEMENT_ENTRIES_F ENTRY
, FND_SESSIONS SESH
WHERE SESH.SESSION_ID = USERENV ('SESSIONID')
AND SESH.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE
AND TYPE.ELEMENT_TYPE_ID = LINK.ELEMENT_TYPE_ID
AND SESH.EFFECTIVE_DATE BETWEEN TYPE.EFFECTIVE_START_DATE
AND TYPE.EFFECTIVE_END_DATE
AND ENTRY.ELEMENT_LINK_ID = LINK.ELEMENT_LINK_ID
AND SESH.EFFECTIVE_DATE BETWEEN ENTRY.EFFECTIVE_START_DATE
AND ENTRY.EFFECTIVE_END_DATE
AND ENTRY.ENTRY_TYPE IN ('A'
, 'R')
AND VALUE.ELEMENT_ENTRY_ID = ENTRY.ELEMENT_ENTRY_ID
AND VALUE.EFFECTIVE_START_DATE = ENTRY.EFFECTIVE_START_DATE
AND VALUE.EFFECTIVE_END_DATE = ENTRY.EFFECTIVE_END_DATE
AND INPVAL.INPUT_VALUE_ID = VALUE.INPUT_VALUE_ID
AND UPPER (INPVAL.NAME) = UPPER ('PAY VALUE')
AND SESH.EFFECTIVE_DATE BETWEEN INPVAL.EFFECTIVE_START_DATE
AND INPVAL.EFFECTIVE_END_DATE