View: PAY_RUN_RESULT_VALUES_V2

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_RUN_RESULT_VALUES_V2

View Text

SELECT PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PRRV.RUN_RESULT_ID RUN_RESULT_ID
, PRRV.INPUT_VALUE_ID INPUT_VALUE_ID
, HR_CHKFMT.CHANGEFORMAT (PRRV.RESULT_VALUE
, PIV.UOM
, PET.OUTPUT_CURRENCY_CODE) DISPLAY_RESULT_VALUE
, PIVTL.NAME INPUT_VALUE_NAME
, LO1.MEANING MANDATORY_FLAG_MEANING
, LO2.MEANING UOM_MEANING
, PIV.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
FROM PAY_INPUT_VALUES_F_TL PIVTL
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV
, HR_LOOKUPS LO2
, HR_LOOKUPS LO1
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND PIV.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID /* DATE EFFECTIVE FILTERING */
AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE /* DECODE NON-USER ENTERABLE TO NOT MANDATORY */
AND LO1.LOOKUP_TYPE = 'YES_NO'
AND LO1.LOOKUP_CODE = DECODE(PIV.MANDATORY_FLAG
, 'X'
, 'N'
, PIV.MANDATORY_FLAG)
AND LO2.LOOKUP_TYPE = 'UNITS'
AND LO2.LOOKUP_CODE = PIV.UOM

Columns