1. Tables and Views for HCM
  2. PER_LEGAL_EMPLOYERS

PER_LEGAL_EMPLOYERS

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

LEGAL_ENTITY_ID

ORGANIZATION_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

BUSINESS_GROUP_ID

NAME

STATUS

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

hao.LEGAL_ENTITY_ID,

hao.ORGANIZATION_ID,

hao.EFFECTIVE_START_DATE,

hao.EFFECTIVE_END_DATE,

hao.BUSINESS_GROUP_ID,

haotl.NAME,

hac.STATUS,

hac.OBJECT_VERSION_NUMBER,

hac.CREATED_BY,

hac.CREATION_DATE,

hac.LAST_UPDATED_BY,

hac.LAST_UPDATE_DATE,

hac.LAST_UPDATE_LOGIN

FROM

HR_ORG_UNIT_CLASSIFICATIONS_F hac,

HR_ALL_ORGANIZATION_UNITS_F hao,

HR_ORGANIZATION_UNITS_F_TL haotl

WHERE

hao.ORGANIZATION_ID = hac.ORGANIZATION_ID AND hao.ORGANIZATION_ID = haotl.ORGANIZATION_ID AND hao.EFFECTIVE_START_DATE BETWEEN hac.EFFECTIVE_START_DATE AND hac.EFFECTIVE_END_DATE AND haotl.LANGUAGE = USERENV('LANG') AND haotl.EFFECTIVE_START_DATE = hao.EFFECTIVE_START_DATE AND haotl.EFFECTIVE_END_DATE = hao.EFFECTIVE_END_DATE AND hac.CLASSIFICATION_CODE = 'HCM_LEMP'