VIEW: APPS.PAY_FORMULA_RESULT_RULES_V

Source

View Text - Preformatted

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')))

View Text - HTML Formatted

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')))