[Home] [Help]
View: PAY_PAYWSMEE_ADJUSTMENT
Product: | PAY - Payroll |
Description: | List of element entries that are an adjustment of another element entry. |
Implementation/DBA Data: |
APPS.PAY_PAYWSMEE_ADJUSTMENT
|
View Text
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
Columns
Name |
ELEMENT_ENTRY_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
TARGET_ENTRY_ID |
ENTRY_TYPE |
ASSIGNMENT_ID |
ELEMENT_LINK_ID |
INPUT_VALUE_ID |
SCREEN_ENTRY_VALUE |
ENTRY_VALUE |
ADJUSTMENT_TYPE |