[Home] [Help]
View: PAY_RUN_RESULT_VALUES_V
View Text
SELECT INVTL.NAME
, INV.EFFECTIVE_START_DATE
, INV.EFFECTIVE_END_DATE
, INV.INPUT_VALUE_ID
, INV.DISPLAY_SEQUENCE
, LO1.MEANING REQUIRED
, LO2.MEANING UNITS
, LO2.LOOKUP_CODE
, INV.LOOKUP_TYPE
, INV.VALUE_SET_ID
, RRV.RESULT_VALUE
, RRV.RUN_RESULT_ID
FROM HR_LOOKUPS LO1
, HR_LOOKUPS LO2
, PAY_INPUT_VALUES_F INV
, PAY_INPUT_VALUES_F_TL INVTL
, PAY_RUN_RESULT_VALUES RRV
WHERE INV.INPUT_VALUE_ID = INVTL.INPUT_VALUE_ID
AND INVTL.LANGUAGE = USERENV('LANG')
AND RRV.INPUT_VALUE_ID = INV.INPUT_VALUE_ID /* DECODE NON-USER ENTERABLE TO NOT MANDATORY */
AND LO1.LOOKUP_TYPE = 'YES_NO'
AND LO1.LOOKUP_CODE = DECODE(INV.MANDATORY_FLAG
, 'X'
, 'N'
, INV.MANDATORY_FLAG)
AND LO2.LOOKUP_TYPE = 'UNITS'
AND LO2.LOOKUP_CODE = INV.UOM
Columns
Name |
NAME |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
INPUT_VALUE_ID |
DISPLAY_SEQUENCE |
REQUIRED |
UNITS |
LOOKUP_CODE |
LOOKUP_TYPE |
VALUE_SET_ID |
RESULT_VALUE |
RUN_RESULT_ID |