VIEW: APPS.HRBV_EVENTS_V

Source

View Text - Preformatted

SELECT EVT.DATE_START, EVT.TYPE, DECODE(EVT.EMP_OR_APL, 'E', DECODE(EVT.EVENT_OR_INTERVIEW, 'E', HR_BIS.BIS_DECODE_LOOKUP('EMP_EVENT_TYPE',EVT.TYPE), 'I', HR_BIS.BIS_DECODE_LOOKUP('EMP_INTERVIEW_TYPE',EVT.TYPE)), 'A', DECODE(EVT.EVENT_OR_INTERVIEW, 'E', HR_BIS.BIS_DECODE_LOOKUP('APL_EVENT_TYPE',EVT.TYPE), 'I', HR_BIS.BIS_DECODE_LOOKUP('APL_INTERVIEW_TYPE',EVT.TYPE))), EVT.COMMENTS, EVT.CONTACT_TELEPHONE_NUMBER, EVT.DATE_END, EVT.EMP_OR_APL, HR_BIS.BIS_DECODE_LOOKUP('EMP_APL',EVT.EMP_OR_APL), EVT.EVENT_OR_INTERVIEW, HR_BIS.BIS_DECODE_LOOKUP('EVENT_INTERVIEW',EVT.EVENT_OR_INTERVIEW), EVT.EXTERNAL_CONTACT, EVT.TIME_END, EVT.TIME_START, '_DF:PER:PER_EVENTS:EVT', EVT.EVENT_ID, EVT.BUSINESS_GROUP_ID, EVT.LOCATION_ID, EVT.INTERNAL_CONTACT_PERSON_ID, EVT.ORGANIZATION_RUN_BY_ID, EVT.ASSIGNMENT_ID, EVT.PARTY_ID, EVT.LAST_UPDATE_DATE, EVT.LAST_UPDATED_BY, EVT.CREATED_BY, EVT.CREATION_DATE, CASE WHEN EVT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, EVT.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_EVENTS EVT WITH READ ONLY

View Text - HTML Formatted

SELECT EVT.DATE_START
, EVT.TYPE
, DECODE(EVT.EMP_OR_APL
, 'E'
, DECODE(EVT.EVENT_OR_INTERVIEW
, 'E'
, HR_BIS.BIS_DECODE_LOOKUP('EMP_EVENT_TYPE'
, EVT.TYPE)
, 'I'
, HR_BIS.BIS_DECODE_LOOKUP('EMP_INTERVIEW_TYPE'
, EVT.TYPE))
, 'A'
, DECODE(EVT.EVENT_OR_INTERVIEW
, 'E'
, HR_BIS.BIS_DECODE_LOOKUP('APL_EVENT_TYPE'
, EVT.TYPE)
, 'I'
, HR_BIS.BIS_DECODE_LOOKUP('APL_INTERVIEW_TYPE'
, EVT.TYPE)))
, EVT.COMMENTS
, EVT.CONTACT_TELEPHONE_NUMBER
, EVT.DATE_END
, EVT.EMP_OR_APL
, HR_BIS.BIS_DECODE_LOOKUP('EMP_APL'
, EVT.EMP_OR_APL)
, EVT.EVENT_OR_INTERVIEW
, HR_BIS.BIS_DECODE_LOOKUP('EVENT_INTERVIEW'
, EVT.EVENT_OR_INTERVIEW)
, EVT.EXTERNAL_CONTACT
, EVT.TIME_END
, EVT.TIME_START
, '_DF:PER:PER_EVENTS:EVT'
, EVT.EVENT_ID
, EVT.BUSINESS_GROUP_ID
, EVT.LOCATION_ID
, EVT.INTERNAL_CONTACT_PERSON_ID
, EVT.ORGANIZATION_RUN_BY_ID
, EVT.ASSIGNMENT_ID
, EVT.PARTY_ID
, EVT.LAST_UPDATE_DATE
, EVT.LAST_UPDATED_BY
, EVT.CREATED_BY
, EVT.CREATION_DATE
, CASE WHEN EVT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EVT.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_EVENTS EVT WITH READ ONLY