VIEW: APPS.HRI_CS_SEPCR_V

Source

View Text - Preformatted

SELECT DECODE(sct.termination_type ,'I','SEP_INV' ,'V','SEP_VOL' ,sct.termination_type) separation_category_code , sct.reason separation_reason_code , hr_general.start_of_time start_date , hr_general.end_of_time end_date , sct.creation_date creation_date , sct.last_update_date last_change_date FROM hri_inv_sprtn_rsns sct WITH READ ONLY

View Text - HTML Formatted

SELECT DECODE(SCT.TERMINATION_TYPE
, 'I'
, 'SEP_INV'
, 'V'
, 'SEP_VOL'
, SCT.TERMINATION_TYPE) SEPARATION_CATEGORY_CODE
, SCT.REASON SEPARATION_REASON_CODE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, SCT.CREATION_DATE CREATION_DATE
, SCT.LAST_UPDATE_DATE LAST_CHANGE_DATE
FROM HRI_INV_SPRTN_RSNS SCT WITH READ ONLY