View: PAY_LINK_INPUT_VALUES_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.PAY_LINK_INPUT_VALUES_D

View Text

SELECT INPLINK.LINK_INPUT_VALUE_ID
, INPLINK.EFFECTIVE_START_DATE
, INPLINK.EFFECTIVE_END_DATE
, HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.LOOKUP_TYPE
, NULL
, DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.DEFAULT_VALUE
, INPUT.DEFAULT_VALUE)
, INPLINK.DEFAULT_VALUE)
, HR_GENERAL.DECODE_LOOKUP(INPUT.LOOKUP_TYPE
, DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.DEFAULT_VALUE
, INPUT.DEFAULT_VALUE)
, INPLINK.DEFAULT_VALUE)))
, INPUT.UOM
, BUS.CURRENCY_CODE) DEFAULT_VALUE
, HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.MAX_VALUE
, INPUT.MAX_VALUE)
, 'N'
, INPLINK.MAX_VALUE)
, INPUT.UOM
, BUS.CURRENCY_CODE) MAX_VALUE
, HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.MIN_VALUE
, INPUT.MIN_VALUE)
, 'N'
, INPLINK.MIN_VALUE)
, INPUT.UOM
, BUS.CURRENCY_CODE) MIN_VALUE
, DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(HR1.MEANING
, HR2.MEANING)
, HR1.MEANING) WARNING_OR_ERROR
, INPLINK.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_LINK_INPUT_VALUES_F INPLINK
, PAY_INPUT_VALUES_F INPUT
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, PER_BUSINESS_GROUPS BUS
, FND_USER FUSER
WHERE INPUT.INPUT_VALUE_ID = INPLINK.INPUT_VALUE_ID
AND INPLINK.EFFECTIVE_START_DATE BETWEEN INPUT.EFFECTIVE_START_DATE
AND INPUT.EFFECTIVE_END_DATE
AND HR1.LOOKUP_CODE (+)= INPLINK.WARNING_OR_ERROR
AND HR1.LOOKUP_TYPE (+)= 'WARNING_ERROR'
AND HR2.LOOKUP_CODE (+)= INPUT.WARNING_OR_ERROR
AND HR2.LOOKUP_TYPE (+)= 'WARNING_ERROR'
AND BUS.BUSINESS_GROUP_ID (+) + 0 = INPUT.BUSINESS_GROUP_ID + 0
AND FUSER.USER_ID (+)= INPLINK.LAST_UPDATED_BY

Columns