View: PER_EVENTS_LOV_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_EVENTS_LOV_V

View Text

SELECT EVT.ASSIGNMENT_ID
, EVT.EVENT_ID
, TO_CHAR (EVT.DATE_START
, FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
, HLU.MEANING
, LOC.LOCATION_CODE
FROM HR_LOCATIONS LOC
, HR_LOOKUPS HLU
, PER_EVENTS EVT
WHERE HLU.LOOKUP_CODE(+) = EVT.TYPE
AND HLU.LOOKUP_TYPE(+) = 'EMP_INTERVIEW_TYPE'
AND EVT.EVENT_OR_INTERVIEW = 'I'
AND EVT.LOCATION_ID = LOC.LOCATION_ID(+)

Columns