VIEW: APPS.IGSBV_EMPLOYMENTS

Source

View Text - Preformatted

SELECT EH.PARTY_ID, EH.BEGIN_DATE, EH.END_DATE, EH.SUPERVISOR_NAME, EH.EMPLOYED_AS_TITLE, EH.EMPLOYED_BY_NAME_COMPANY, EH.EMPLOYED_BY_DIVISION_NAME, EH.BRANCH, EH.MILITARY_RANK, EH.SERVED, EH.STATION, '_LA:EH.EMPLOYMENT_TYPE_CODE:AR_LOOKUPS:HZ_EMPLOYMENT_TYPE:MEANING' , EH.FRACTION_OF_TENURE FRACTION_OF_EMPLOYMENT, '_LA:EH.TENURE_CODE:AR_LOOKUPS:HZ_TENURE_CODE:MEANING' , HED.OCCUPATIONAL_TITLE_CODE, EH.WEEKLY_WORK_HOURS, EH.COMMENTS, EH.REASON_FOR_LEAVING, EH.EMPLOYED_BY_PARTY_ID, HED.HZ_EMP_DTL_ID, EH.EMPLOYMENT_HISTORY_ID, EH.CREATED_BY, EH.CREATION_DATE, EH.LAST_UPDATED_BY, EH.LAST_UPDATE_DATE FROM IGS_AD_HZ_EMP_DTL HED, HZ_EMPLOYMENT_HISTORY EH WHERE EH.EMPLOYMENT_HISTORY_ID=HED.EMPLOYMENT_HISTORY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT EH.PARTY_ID
, EH.BEGIN_DATE
, EH.END_DATE
, EH.SUPERVISOR_NAME
, EH.EMPLOYED_AS_TITLE
, EH.EMPLOYED_BY_NAME_COMPANY
, EH.EMPLOYED_BY_DIVISION_NAME
, EH.BRANCH
, EH.MILITARY_RANK
, EH.SERVED
, EH.STATION
, '_LA:EH.EMPLOYMENT_TYPE_CODE:AR_LOOKUPS:HZ_EMPLOYMENT_TYPE:MEANING'
, EH.FRACTION_OF_TENURE FRACTION_OF_EMPLOYMENT
, '_LA:EH.TENURE_CODE:AR_LOOKUPS:HZ_TENURE_CODE:MEANING'
, HED.OCCUPATIONAL_TITLE_CODE
, EH.WEEKLY_WORK_HOURS
, EH.COMMENTS
, EH.REASON_FOR_LEAVING
, EH.EMPLOYED_BY_PARTY_ID
, HED.HZ_EMP_DTL_ID
, EH.EMPLOYMENT_HISTORY_ID
, EH.CREATED_BY
, EH.CREATION_DATE
, EH.LAST_UPDATED_BY
, EH.LAST_UPDATE_DATE
FROM IGS_AD_HZ_EMP_DTL HED
, HZ_EMPLOYMENT_HISTORY EH
WHERE EH.EMPLOYMENT_HISTORY_ID=HED.EMPLOYMENT_HISTORY_ID WITH READ ONLY