View: PAY_JP_SOE_RUN_RESULTS_V

Product:	PAY - Payroll
Description:	Used in PAYJPSOE.fmb.
Implementation/DBA Data:	APPS.PAY_JP_SOE_RUN_RESULTS_V

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID
, PRR.RUN_RESULT_ID
, PET.ELEMENT_TYPE_ID
, PET.ELEMENT_NAME
, PEC.CLASSIFICATION_NAME
, PIV.INPUT_VALUE_ID
, PIV.UOM
, PIV.NAME
, PIV.DISPLAY_SEQUENCE
, PRRV.RESULT_VALUE
, SUBSTRB(DECODE(PIV.LOOKUP_TYPE
, NULL
, PRRV.RESULT_VALUE
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PRRV.RESULT_VALUE))
, 1
, 80)
, DECODE(PIV.NAME
, 'PAY VALUE'
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME)
, PIVTL.NAME)
, PET.PROCESSING_PRIORITY FROM PAY_INPUT_VALUES_F_TL PIVTL
, PAY_RUN_RESULT_VALUES PRRV
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_TYPES_F PET
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PRR.STATUS IN ('P'
, 'PA') AND PET.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PETTL.LANGUAGE = USERENV('LANG') AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE AND PRRV.RUN_RESULT_ID = NVL(PRR.RUN_RESULT_ID
, PIV.INPUT_VALUE_ID) AND PRRV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID AND PIVTL.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID AND PIVTL.LANGUAGE = USERENV('LANG')

Columns