Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_INPUT_VALUES_V |
SELECT PIV.ROWID ROW_ID
, PIV.INPUT_VALUE_ID
, PIV.EFFECTIVE_START_DATE
, PIV.EFFECTIVE_END_DATE
, PIV.ELEMENT_TYPE_ID
, PIV.LOOKUP_TYPE
, PIV.VALUE_SET_ID
, FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME
, PIV.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PIV.LEGISLATION_CODE
, PIV.FORMULA_ID
, PIV.DISPLAY_SEQUENCE
, PIVTL.NAME
, PIV.NAME BASE_NAME
, PIV.DEFAULT_VALUE
, DECODE(PIV.DEFAULT_VALUE
, NULL
, NULL
, DECODE (PIV.LOOKUP_TYPE
, NULL
, DECODE (PIV.VALUE_SET_ID
, NULL
, HR_CHKFMT.CHANGEFORMAT ( PIV.DEFAULT_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, PAY_INPUT_VALUES_PKG.DECODE_VSET_VALUE (PIV.VALUE_SET_ID
, PIV.DEFAULT_VALUE) )
, HR_GENERAL.DECODE_LOOKUP (PIV.LOOKUP_TYPE
, PIV.DEFAULT_VALUE))) D_DEFAULT_VALUE
, PIV.LEGISLATION_SUBGROUP
, PIV.MAX_VALUE
, HR_CHKFMT.CHANGEFORMAT ( PIV.MAX_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE) D_MAX_VALUE
, PIV.MIN_VALUE
, HR_CHKFMT.CHANGEFORMAT ( PIV.MIN_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE) D_MIN_VALUE
, PIV.LAST_UPDATE_DATE
, PIV.LAST_UPDATED_BY
, PIV.LAST_UPDATE_LOGIN
, PIV.CREATED_BY
, PIV.CREATION_DATE
, PIV.HOT_DEFAULT_FLAG
, PIV.GENERATE_DB_ITEMS_FLAG
, PIV.UOM
, HR_GENERAL.DECODE_LOOKUP ('UNITS'
, PIV.UOM) UNIT_OF_MEASURE
, PIV.MANDATORY_FLAG
, DECODE(MANDATORY_FLAG
, 'Y'
, 'Y'
, 'N') MANDATORY_FLAG_NAME
, DECODE(MANDATORY_FLAG
, 'X'
, 'N'
, 'Y') USER_ENTERABLE_FLAG
, PIV.WARNING_OR_ERROR
, HR_GENERAL.DECODE_LOOKUP ('WARNING_ERROR'
, PIV.WARNING_OR_ERROR) WARNING_OR_ERROR_NAME
, FF.FORMULA_NAME FORMULA_NAME
FROM PAY_INPUT_VALUES_F_TL PIVTL
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F ELEMENT
, FF_FORMULAS_F FF
, FND_FLEX_VALUE_SETS FFVS
, FND_SESSIONS FND
WHERE PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PIV.FORMULA_ID = FF.FORMULA_ID(+)
AND PIV.VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID (+)
AND ELEMENT.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND (USERENV('SESSIONID') = FND.SESSION_ID
AND FND.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND (FF.FORMULA_ID IS NULL OR FND.EFFECTIVE_DATE BETWEEN FF.EFFECTIVE_START_DATE
AND FF.EFFECTIVE_END_DATE))