VIEW: APPS.PER_EVENTS_LOV_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)