VIEW: APPS.PAY_RUN_RESULT_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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