VIEW: APPS.IGS_PE_HR_EMP_CAT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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