1. Tables and Views for HCM
  2. PER_GRADES_IN_LADDERS_X

PER_GRADES_IN_LADDERS_X

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

GRADES_IN_LADDER_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

ACTION_OCCURRENCE_ID

GRADE_LADDER_ID

GRADE_ID

SEQUENCE

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

GRADES_IN_LADDER_ID,

EFFECTIVE_START_DATE,

EFFECTIVE_END_DATE,

ACTION_OCCURRENCE_ID,

GRADE_LADDER_ID,

GRADE_ID,

SEQUENCE,

OBJECT_VERSION_NUMBER,

CREATED_BY,

CREATION_DATE,

LAST_UPDATED_BY,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN

FROM

PER_GRADES_IN_LADDERS_F

WHERE

TRUNC(sysdate) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE