View: IGS_PE_HR_EMP_CAT_V

View Text

SELECT ASSIGN.ROWID ROW_ID
, PEO.PARTY_ID PERSON_ID
, ASSIGN.EMPLOYMENT_CATEGORY EMPLMNT_CATEGORY_CODE
, LKUP.MEANING EMP_CATEGORY_MEANING
, ASSIGN.CREATED_BY
, ASSIGN.CREATION_DATE
, ASSIGN.LAST_UPDATED_BY
, ASSIGN.LAST_UPDATE_DATE
, ASSIGN.LAST_UPDATE_LOGIN
FROM PER_ALL_ASSIGNMENTS_F ASSIGN
, PER_ALL_PEOPLE_F PEO
, HR_LOOKUPS LKUP
WHERE PEO.PERSON_ID = ASSIGN.PERSON_ID
AND ASSIGN.ASSIGNMENT_TYPE = 'E'
AND ASSIGN.PRIMARY_FLAG= 'Y'
AND TRUNC(SYSDATE) BETWEEN ASSIGN.EFFECTIVE_START_DATE
AND ASSIGN.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND LKUP.LOOKUP_TYPE = 'EMP_CAT'
AND LKUP.LOOKUP_CODE = ASSIGN.EMPLOYMENT_CATEGORY

Columns