1. Tables and Views for HCM
  2. PAY_VALUE_CRITERIA_LEVELS_VL

PAY_VALUE_CRITERIA_LEVELS_VL

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

VALUE_CRITERIA_LEVEL_ID

VO_NAME

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

VALUE_DEFN_ID

CRITERIA_LEVEL

DATABASE_ITEM_ID

ENTERPRISE_ID

LEGISLATIVE_DATA_GROUP_ID

LEGISLATION_CODE

LABEL

SEED_STATUS

Query

SQL_Statement

SELECT

PAY_VALUE_CRITERIA_LEVELS_F.VALUE_CRITERIA_LEVEL_ID,

PAY_VALUE_CRITERIA_LEVELS_F.VO_NAME,

PAY_VALUE_CRITERIA_LEVELS_F.EFFECTIVE_START_DATE,

PAY_VALUE_CRITERIA_LEVELS_F.EFFECTIVE_END_DATE,

PAY_VALUE_CRITERIA_LEVELS_F.VALUE_DEFN_ID,

PAY_VALUE_CRITERIA_LEVELS_F.CRITERIA_LEVEL,

PAY_VALUE_CRITERIA_LEVELS_F.DATABASE_ITEM_ID,

PAY_VALUE_CRITERIA_LEVELS_F.ENTERPRISE_ID,

PAY_VALUE_CRITERIA_LEVELS_F.LEGISLATIVE_DATA_GROUP_ID,

PAY_VALUE_CRITERIA_LEVELS_F.LEGISLATION_CODE,

PAY_VALUE_CRITERIA_LEVELS_TL.LABEL,

PAY_VALUE_CRITERIA_LEVELS_F.SEED_STATUS

FROM

PAY_VALUE_CRITERIA_LEVELS_F,

PAY_VALUE_CRITERIA_LEVELS_TL

WHERE

PAY_VALUE_CRITERIA_LEVELS_F.VALUE_CRITERIA_LEVEL_ID = PAY_VALUE_CRITERIA_LEVELS_TL.VALUE_CRITERIA_LEVEL_ID AND PAY_VALUE_CRITERIA_LEVELS_TL.LANGUAGE = USERENV('LANG')