HRY_VALUE_MAP_RULESET_VL

Details

• Schema: FUSION

• Object owner: HRY

• Object type: VIEW

Columns

Name
RULE_SET_ID BASE_RULE_SET_NAME EXT_DEFINITION_ID LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE VENDOR_NAME PAYROLL_ID XSL_TEMPLATE XSLT_GENERATED_DATE STATUS SGUID SEED_DATA_SOURCE MODULE_ID ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ORA_SEED_SET1 ORA_SEED_SET2 RULE_SET_NAME DESCRIPTION

Query

SQL_Statement

SELECT objects.RULE_SET_ID RULE_SET_ID, objects.BASE_RULE_SET_NAME BASE_RULE_SET_NAME, objects.EXT_DEFINITION_ID EXT_DEFINITION_ID, objects.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, objects.LEGISLATION_CODE LEGISLATION_CODE, objects.VENDOR_NAME VENDOR_NAME, objects.PAYROLL_ID PAYROLL_ID, objects.XSL_TEMPLATE XSL_TEMPLATE, objects.XSLT_GENERATED_DATE XSLT_GENERATED_DATE, objects.STATUS STATUS, objects.SGUID SGUID, objects.SEED_DATA_SOURCE SEED_DATA_SOURCE, objects.MODULE_ID MODULE_ID, objects.ENTERPRISE_ID ENTERPRISE_ID, objects.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, objects.CREATED_BY CREATED_BY, objects.CREATION_DATE CREATION_DATE, objects.LAST_UPDATED_BY LAST_UPDATED_BY, objects.LAST_UPDATE_DATE LAST_UPDATE_DATE, objects.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, objects.ORA_SEED_SET1 ORA_SEED_SET1, objects.ORA_SEED_SET2 ORA_SEED_SET2, objects_tl.RULE_SET_NAME RULE_SET_NAME, objects_tl.DESCRIPTION DESCRIPTION FROM HRY_VALUE_MAP_RULESET_B objects, HRY_VALUE_MAP_RULESET_TL objects_tl WHERE objects.rule_set_id = objects_tl.rule_set_id AND objects_tl.language = USERENV('LANG')