View: PAY_FORMULA_RESULT_RULES_V

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

View Text

SELECT RESULT_RULE.FORMULA_RESULT_RULE_ID
, RESULT_RULE.EFFECTIVE_START_DATE
, RESULT_RULE.EFFECTIVE_END_DATE
, RESULT_RULE.BUSINESS_GROUP_ID
, RESULT_RULE.LEGISLATION_CODE
, RESULT_RULE.ELEMENT_TYPE_ID
, RESULT_RULE.STATUS_PROCESSING_RULE_ID
, RESULT_RULE.RESULT_NAME
, RESULT_RULE.RESULT_RULE_TYPE
, RESULT_RULE.LEGISLATION_SUBGROUP
, RESULT_RULE.SEVERITY_LEVEL
, RESULT_RULE.INPUT_VALUE_ID
, RESULT_RULE.LAST_UPDATE_DATE
, RESULT_RULE.LAST_UPDATED_BY
, RESULT_RULE.LAST_UPDATE_LOGIN
, RESULT_RULE.CREATED_BY
, RESULT_RULE.CREATION_DATE
, RESULT_RULE.ROWID ROW_ID
, HR_GENERAL.DECODE_LOOKUP('RESULT_RULE_TYPE'
, RESULT_RULE.RESULT_RULE_TYPE) RULE_TYPE_NAME
, HR_GENERAL.DECODE_LOOKUP('FORMULA_RESULT_MESSAGE_LEVEL'
, RESULT_RULE.SEVERITY_LEVEL) SEVERITY_LEVEL_NAME
, VALUETL.NAME INPUT_VALUE_NAME
, INPUT_VALUE.UOM INPUT_DATA_TYPE
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, INPUT_VALUE.UOM) UNIT_OF_MEASURE
, ELEMENTTL.ELEMENT_NAME
FROM PAY_FORMULA_RESULT_RULES_F RESULT_RULE
, PAY_INPUT_VALUES_F_TL VALUETL
, PAY_INPUT_VALUES_F INPUT_VALUE
, PAY_STATUS_PROCESSING_RULES_F SPR
, PAY_ELEMENT_TYPES_F_TL ELEMENTTL
, PAY_ELEMENT_TYPES_F ELEMENT
, FND_SESSIONS CURRENT_SESSION
WHERE ELEMENTTL.ELEMENT_TYPE_ID (+) = ELEMENT.ELEMENT_TYPE_ID
AND DECODE (ELEMENTTL.ELEMENT_TYPE_ID
, NULL
, '1'
, ELEMENTTL.LANGUAGE) = DECODE (ELEMENTTL.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND VALUETL.INPUT_VALUE_ID (+) = INPUT_VALUE.INPUT_VALUE_ID
AND DECODE (VALUETL.INPUT_VALUE_ID
, NULL
, '1'
, VALUETL.LANGUAGE) = DECODE (VALUETL.INPUT_VALUE_ID
, NULL
, '1'
, USERENV('LANG'))
AND RESULT_RULE.ELEMENT_TYPE_ID = ELEMENT.ELEMENT_TYPE_ID(+)
AND RESULT_RULE.STATUS_PROCESSING_RULE_ID = SPR.STATUS_PROCESSING_RULE_ID
AND RESULT_RULE.INPUT_VALUE_ID = INPUT_VALUE.INPUT_VALUE_ID(+)
AND (CURRENT_SESSION.SESSION_ID = USERENV ('SESSIONID')
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN RESULT_RULE.EFFECTIVE_START_DATE
AND RESULT_RULE.EFFECTIVE_END_DATE
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN NVL(SPR.EFFECTIVE_START_DATE
, TO_DATE('01/01/0001'
, 'DD/MM/YYYY'))
AND NVL(SPR.EFFECTIVE_END_DATE
, TO_DATE('31/12/4712'
, 'DD/MM/YYYY'))
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN NVL(ELEMENT.EFFECTIVE_START_DATE
, TO_DATE('01/01/0001'
, 'DD/MM/YYYY'))
AND NVL(ELEMENT.EFFECTIVE_END_DATE
, TO_DATE('31/12/4712'
, 'DD/MM/YYYY'))
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN NVL(INPUT_VALUE.EFFECTIVE_START_DATE
, TO_DATE('01/01/0001'
, 'DD/MM/YYYY'))
AND NVL(INPUT_VALUE.EFFECTIVE_END_DATE
, TO_DATE('31/12/4712'
, 'DD/MM/YYYY')))

Columns