View: PAY_INPUT_VALUES_D

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

View Text

SELECT INPUT.INPUT_VALUE_ID
, INPUT.EFFECTIVE_START_DATE
, INPUT.EFFECTIVE_END_DATE
, INPUT.LOOKUP_TYPE
, FORMULA.FORMULA_NAME
, INPUT.DISPLAY_SEQUENCE
, DECODE(INPUT.MANDATORY_FLAG
, 'Y'
, 'YES'
, 'NO') REQUIRED
, DECODE(INPUT.MANDATORY_FLAG
, 'X'
, 'NO'
, 'YES') USER_ENTERABLE
, HR1.MEANING
, INPUT.DEFAULT_VALUE
, INPUT.MAX_VALUE
, INPUT.MIN_VALUE
, HR2.MEANING
, INPUT.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_INPUT_VALUES_F INPUT
, FF_FORMULAS_F FORMULA
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, FND_USER FUSER
WHERE FORMULA.FORMULA_ID (+)= INPUT.FORMULA_ID
AND INPUT.EFFECTIVE_START_DATE BETWEEN NVL (FORMULA.EFFECTIVE_START_DATE
, INPUT.EFFECTIVE_START_DATE)
AND NVL (FORMULA.EFFECTIVE_END_DATE
, INPUT.EFFECTIVE_START_DATE)
AND HR1.LOOKUP_CODE (+)= INPUT.UOM
AND HR1.LOOKUP_TYPE (+)= 'UNITS'
AND HR2.LOOKUP_CODE (+)= INPUT.WARNING_OR_ERROR
AND HR2.LOOKUP_TYPE (+)= 'WARNING_ERROR'
AND FUSER.USER_ID (+)= INPUT.LAST_UPDATED_BY

Columns