VIEW: APPS.AMS_LT_HZ_EMPLOYMENT_HISTORY

Source

View Text - Preformatted

SELECT EMPLOYMENT_HISTORY_ID , BEGIN_DATE , PARTY_ID , EMPLOYED_AS_TITLE , EMPLOYED_BY_DIVISION_NAME , EMPLOYED_BY_NAME_COMPANY , SUPERVISOR_NAME , BRANCH , MILITARY_RANK , SERVED , STATION , RESPONSIBILITY from HZ_EMPLOYMENT_HISTORY WHERE END_DATE is null and status = 'A'

View Text - HTML Formatted

SELECT EMPLOYMENT_HISTORY_ID
, BEGIN_DATE
, PARTY_ID
, EMPLOYED_AS_TITLE
, EMPLOYED_BY_DIVISION_NAME
, EMPLOYED_BY_NAME_COMPANY
, SUPERVISOR_NAME
, BRANCH
, MILITARY_RANK
, SERVED
, STATION
, RESPONSIBILITY
FROM HZ_EMPLOYMENT_HISTORY
WHERE END_DATE IS NULL
AND STATUS = 'A'