View: PAY_RUN_RESULTS_V

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

View Text

SELECT /*+ INDEX (RRV PAY_RUN_RESULT_VALUES_PK) */ RRS.ASSIGNMENT_ACTION_ID
, RRS.RUN_RESULT_ID
, ETYTL.ELEMENT_NAME
, HR_GENERAL.START_OF_TIME ELE_START_DATE
, HR_GENERAL.END_OF_TIME ELE_END_DATE
, CLATL.CLASSIFICATION_NAME
, DECODE ( RRS.STATUS
, 'R'
, LO1.MEANING
, 'O'
, LO1.MEANING
, 'PA'
, LO1.MEANING
, NULL ) MODIFIED
, ETY.OUTPUT_CURRENCY_CODE
, RRV.RESULT_VALUE RESULT_VALUE
, HR_GENERAL.START_OF_TIME INV_START_DATE
, HR_GENERAL.END_OF_TIME INV_END_DATE
, INV.UOM UOM
, LO2.MEANING UNITS
, INV.INPUT_VALUE_ID
, RRS.START_DATE
, RRS.END_DATE
, ETY.PROCESSING_PRIORITY PROCESSING_PRIORITY
FROM PAY_ELEMENT_TYPES_F ETY
, PAY_ELEMENT_TYPES_F_TL ETYTL
, PAY_ELEMENT_CLASSIFICATIONS CLA
, PAY_ELEMENT_CLASSIFICATIONS_TL CLATL
, PAY_RUN_RESULT_VALUES RRV
, PAY_INPUT_VALUES_F INV
, PAY_RUN_RESULTS RRS
, ( SELECT MEANING
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'RUN_RESULT_STATUS' ) LO1
, ( SELECT MEANING
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'UNITS' ) LO2
, PAY_ASSIGNMENT_ACTIONS ASACT
, PAY_PAYROLL_ACTIONS PACT
WHERE ETY.ELEMENT_TYPE_ID = ETYTL.ELEMENT_TYPE_ID
AND ETYTL.LANGUAGE = USERENV('LANG')
AND CLA.CLASSIFICATION_ID = CLATL.CLASSIFICATION_ID
AND CLATL.LANGUAGE = USERENV('LANG')
AND INV.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND RRS.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND CLA.CLASSIFICATION_ID = ETY.CLASSIFICATION_ID
AND PACT.PAYROLL_ACTION_ID = ASACT.PAYROLL_ACTION_ID
AND ASACT.ASSIGNMENT_ACTION_ID = RRS.ASSIGNMENT_ACTION_ID
AND RRS.RUN_RESULT_ID = RRV.RUN_RESULT_ID
AND RRV.INPUT_VALUE_ID = INV.INPUT_VALUE_ID
AND LO1.LOOKUP_CODE = RRS.STATUS
AND INV.NAME = 'PAY VALUE'
AND LO2.LOOKUP_CODE = INV.UOM
AND PACT.EFFECTIVE_DATE BETWEEN INV.EFFECTIVE_START_DATE
AND INV.EFFECTIVE_END_DATE
AND PACT.EFFECTIVE_DATE BETWEEN ETY.EFFECTIVE_START_DATE
AND ETY.EFFECTIVE_END_DATE UNION SELECT RRS.ASSIGNMENT_ACTION_ID
, RRS.RUN_RESULT_ID
, ETYTL.ELEMENT_NAME
, ETY.EFFECTIVE_START_DATE ELE_START_DATE
, ETY.EFFECTIVE_END_DATE ELE_END_DATE
, CLATL.CLASSIFICATION_NAME
, DECODE ( RRS.STATUS
, 'R'
, LO1.MEANING
, 'O'
, LO1.MEANING
, 'PA'
, LO1.MEANING
, NULL ) MODIFIED
, ETY.OUTPUT_CURRENCY_CODE
, NULL RESULT_VALUE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01') INV_START_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31') INV_END_DATE
, NULL UOM
, NULL UNITS
, FND_NUMBER.CANONICAL_TO_NUMBER(NULL) INPUT_VALUE_ID
, RRS.START_DATE
, RRS.END_DATE
, ETY.PROCESSING_PRIORITY PROCESSING_PRIORITY
FROM PAY_ELEMENT_TYPES_F ETY
, PAY_ELEMENT_TYPES_F_TL ETYTL
, PAY_ELEMENT_CLASSIFICATIONS_TL CLATL
, PAY_ELEMENT_CLASSIFICATIONS CLA
, ( SELECT MEANING
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'RUN_RESULT_STATUS' ) LO1
, PAY_RUN_RESULTS RRS
, PAY_ASSIGNMENT_ACTIONS ASACT
, PAY_PAYROLL_ACTIONS PACT
WHERE ETY.ELEMENT_TYPE_ID = ETYTL.ELEMENT_TYPE_ID
AND ETYTL.LANGUAGE = USERENV('LANG')
AND CLA.CLASSIFICATION_ID = CLATL.CLASSIFICATION_ID
AND CLATL.LANGUAGE = USERENV('LANG')
AND RRS.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND CLA.CLASSIFICATION_ID = ETY.CLASSIFICATION_ID
AND LO1.LOOKUP_CODE = RRS.STATUS
AND PACT.PAYROLL_ACTION_ID = ASACT.PAYROLL_ACTION_ID
AND ASACT.ASSIGNMENT_ACTION_ID = RRS.ASSIGNMENT_ACTION_ID
AND PACT.EFFECTIVE_DATE BETWEEN ETY.EFFECTIVE_START_DATE
AND ETY.EFFECTIVE_END_DATE
AND NOT EXISTS ( SELECT /*+ ORDERED INDEX(INV2 PAY_INPUT_VALUES_F_N50) INDEX(RRV2 PAY_RUN_RESULT_VALUES_PK) USE_NL(INV2 RRV2) */ 1
FROM PAY_INPUT_VALUES_F INV2
, PAY_RUN_RESULT_VALUES RRV2
WHERE RRV2.RUN_RESULT_ID = RRS.RUN_RESULT_ID
AND RRV2.INPUT_VALUE_ID = INV2.INPUT_VALUE_ID
AND INV2.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND PACT.EFFECTIVE_DATE BETWEEN INV2.EFFECTIVE_START_DATE
AND INV2.EFFECTIVE_END_DATE
AND INV2.NAME = 'PAY VALUE' )

Columns