VIEW: APPS.PAYBV_LINK_INPUT_VALUES_F_V

Source

View Text - Preformatted

SELECT hr_bis.bis_decode_lookup('YES_NO',LIV.COSTED_FLAG) COSTED_FLAG_M , hr_bis.bis_decode_lookup('WARNING_ERROR',LIV.WARNING_OR_ERROR) WARNING_OR_ERROR_M , LIV.DEFAULT_VALUE , LIV.MAX_VALUE , LIV.MIN_VALUE , LIV.EFFECTIVE_START_DATE , LIV.EFFECTIVE_END_DATE , LIV.COSTED_FLAG , LIV.WARNING_OR_ERROR , LIV.LINK_INPUT_VALUE_ID , LIV.ELEMENT_LINK_ID , LIV.INPUT_VALUE_ID , LIV.LAST_UPDATE_DATE , LIV.LAST_UPDATED_BY , LIV.LAST_UPDATE_LOGIN , LIV.CREATED_BY , LIV.CREATION_DATE , LIV.OBJECT_VERSION_NUMBER FROM PAY_LINK_INPUT_VALUES_F LIV WITH READ ONLY

View Text - HTML Formatted

SELECT HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LIV.COSTED_FLAG) COSTED_FLAG_M
, HR_BIS.BIS_DECODE_LOOKUP('WARNING_ERROR'
, LIV.WARNING_OR_ERROR) WARNING_OR_ERROR_M
, LIV.DEFAULT_VALUE
, LIV.MAX_VALUE
, LIV.MIN_VALUE
, LIV.EFFECTIVE_START_DATE
, LIV.EFFECTIVE_END_DATE
, LIV.COSTED_FLAG
, LIV.WARNING_OR_ERROR
, LIV.LINK_INPUT_VALUE_ID
, LIV.ELEMENT_LINK_ID
, LIV.INPUT_VALUE_ID
, LIV.LAST_UPDATE_DATE
, LIV.LAST_UPDATED_BY
, LIV.LAST_UPDATE_LOGIN
, LIV.CREATED_BY
, LIV.CREATION_DATE
, LIV.OBJECT_VERSION_NUMBER
FROM PAY_LINK_INPUT_VALUES_F LIV WITH READ ONLY