1. Tables and Views for HCM
  2. CEL_PROGRAMS_VL

CEL_PROGRAMS_VL

Details

  • Schema: FUSION

  • Object owner: CEL

  • Object type: VIEW

Columns

Name

PROGRAM_ID

PROGRAM_NAME

TYPE_CODE

AWARD_TYPE_CODE

OWNERS_ENABLED_FLAG

START_DATE

END_DATE

USE_POINTS_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DESCRIPTION

AWARD_DESCRIPTION

Query

SQL_Statement

SELECT B.PROGRAM_ID,

T.PROGRAM_NAME, B.TYPE_CODE,

B.AWARD_TYPE_CODE,

B.OWNERS_ENABLED_FLAG,

B.START_DATE,

B.END_DATE,

B.USE_POINTS_FLAG,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

T.DESCRIPTION,

T.AWARD_DESCRIPTION

FROM CEL_PROGRAMS_B B, CEL_PROGRAMS_TL T WHERE B.PROGRAM_ID = T.PROGRAM_ID AND T.LANGUAGE = USERENV('LANG')