View: PAY_FORMULA_RESULT_RULES_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.PAY_FORMULA_RESULT_RULES_D

View Text

SELECT FR.FORMULA_RESULT_RULE_ID
, FR.EFFECTIVE_START_DATE
, FR.EFFECTIVE_END_DATE
, FR.RESULT_NAME
, RT.MEANING
, ELTL.ELEMENT_NAME
, IVTL.NAME
, UT.MEANING
, SV.MEANING
, FR.LAST_UPDATE_DATE
, FU.USER_NAME
FROM PAY_FORMULA_RESULT_RULES_F FR
, PAY_INPUT_VALUES_F_TL IVTL
, PAY_INPUT_VALUES_F IV
, PAY_ELEMENT_TYPES_F_TL ELTL
, PAY_ELEMENT_TYPES_F EL
, HR_LOOKUPS RT
, HR_LOOKUPS SV
, HR_LOOKUPS UT
, FND_USER FU
WHERE EL.ELEMENT_TYPE_ID = ELTL.ELEMENT_TYPE_ID (+)
AND DECODE(ELTL.ELEMENT_TYPE_ID
, NULL
, '1'
, ELTL.LANGUAGE) = DECODE(ELTL.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND IV.INPUT_VALUE_ID = IVTL.INPUT_VALUE_ID (+)
AND DECODE(IVTL.INPUT_VALUE_ID
, NULL
, '1'
, IVTL.LANGUAGE) = DECODE(IVTL.INPUT_VALUE_ID
, NULL
, '1'
, USERENV('LANG'))
AND FR.ELEMENT_TYPE_ID = EL.ELEMENT_TYPE_ID(+)
AND FR.EFFECTIVE_START_DATE BETWEEN NVL(EL.EFFECTIVE_START_DATE
, FR.EFFECTIVE_START_DATE)
AND NVL(EL.EFFECTIVE_END_DATE
, FR.EFFECTIVE_START_DATE)
AND FR.INPUT_VALUE_ID = IV.INPUT_VALUE_ID(+)
AND FR.EFFECTIVE_START_DATE BETWEEN NVL(IV.EFFECTIVE_START_DATE
, FR.EFFECTIVE_START_DATE)
AND NVL(IV.EFFECTIVE_END_DATE
, FR.EFFECTIVE_START_DATE)
AND (FR.RESULT_RULE_TYPE = RT.LOOKUP_CODE
AND RT.LOOKUP_TYPE = 'RESULT_RULE_TYPE')
AND (IV.UOM = UT.LOOKUP_CODE(+)
AND (UT.LOOKUP_TYPE = 'UNITS' OR UT.LOOKUP_TYPE IS NULL))
AND (FR.SEVERITY_LEVEL = SV.LOOKUP_CODE(+)
AND (SV.LOOKUP_TYPE = 'FORMULA_RESULT_MESSAGE_LEVEL' OR SV.LOOKUP_TYPE IS NULL))
AND FU.USER_ID (+)= FR.LAST_UPDATED_BY

Columns