View: PAY_RUN_RESULT_VALUES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.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