VIEW: APPS.HRI_OBI_CL_WEVT_EVTYPCMB_V

Source

View Text - Preformatted

SELECT ETCB_evtypcmb_PK ,ETCB_ASSGNMNT_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_ASSGNMNT_CHNG_FLAG_CODE) ETCB_ASSGNMNT_CHNG_FLAG ,ETCB_SALARY_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_SALARY_CHNG_FLAG_CODE) ETCB_SALARY_CHNG_FLAG ,ETCB_PRFRTNG_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_PRFRTNG_CHNG_FLAG_CODE) ETCB_PRFRTNG_CHNG_FLAG ,ETCB_PERFBAND_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_PERFBAND_CHNG_FLAG_CODE) ETCB_PERFBAND_CHNG_FLAG ,ETCB_POWBAND_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_POWBAND_CHNG_FLAG_CODE) ETCB_POWBAND_CHNG_FLAG ,ETCB_HDC_GAIN_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_HDC_GAIN_FLAG_CODE) ETCB_HDC_GAIN_FLAG ,ETCB_HDC_LOSS_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_HDC_LOSS_FLAG_CODE) ETCB_HDC_LOSS_FLAG ,ETCB_HDC_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_HDC_CHNG_FLAG_CODE) ETCB_HDC_CHNG_FLAG ,ETCB_FTE_GAIN_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_FTE_GAIN_FLAG_CODE) ETCB_FTE_GAIN_FLAG ,ETCB_FTE_LOSS_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_FTE_LOSS_FLAG_CODE) ETCB_FTE_LOSS_FLAG ,ETCB_FTE_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_FTE_CHNG_FLAG_CODE) ETCB_FTE_CHNG_FLAG ,ETCB_GRD_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_GRD_CHNG_FLAG_CODE) ETCB_GRD_CHNG_FLAG ,ETCB_JOB_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_JOB_CHNG_FLAG_CODE) ETCB_JOB_CHNG_FLAG ,ETCB_POS_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_POS_CHNG_FLAG_CODE) ETCB_POS_CHNG_FLAG ,ETCB_LOC_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_LOC_CHNG_FLAG_CODE) ETCB_LOC_CHNG_FLAG ,ETCB_ORG_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_ORG_CHNG_FLAG_CODE) ETCB_ORG_CHNG_FLAG ,ETCB_MGRH_CHNG_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_MGRH_CHNG_FLAG_CODE) ETCB_MGRH_CHNG_FLAG ,ETCB_HIRE_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_HIRE_FLAG_CODE) ETCB_HIRE_FLAG ,ETCB_ASG_START_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_ASG_START_FLAG_CODE) ETCB_ASG_START_FLAG ,ETCB_HIRE_OR_START_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_HIRE_OR_START_FLAG_CODE) ETCB_HIRE_OR_START_FLAG ,ETCB_TERM_OR_END_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_TERM_OR_END_FLAG_CODE) ETCB_TERM_OR_END_FLAG ,ETCB_TERM_VOL_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_TERM_VOL_FLAG_CODE) ETCB_TERM_VOL_FLAG ,ETCB_TERM_INVOL_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_TERM_INVOL_FLAG_CODE) ETCB_TERM_INVOL_FLAG ,ETCB_TERM_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_TERM_FLAG_CODE) ETCB_TERM_FLAG ,ETCB_ASG_END_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_ASG_END_FLAG_CODE) ETCB_ASG_END_FLAG ,ETCB_START_SSPNSN_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_START_SSPNSN_FLAG_CODE) ETCB_START_SSPNSN_FLAG ,ETCB_END_SSPNSN_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_END_SSPNSN_FLAG_CODE) ETCB_END_SSPNSN_FLAG ,ETCB_PRMTN_FLAG_CODE ,hr_general.decode_lookup('YES_NO', ETCB_PRMTN_FLAG_CODE) ETCB_PRMTN_FLAG from hri_cl_wevt_evtypcmb_ct

View Text - HTML Formatted

SELECT ETCB_EVTYPCMB_PK
, ETCB_ASSGNMNT_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_ASSGNMNT_CHNG_FLAG_CODE) ETCB_ASSGNMNT_CHNG_FLAG
, ETCB_SALARY_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_SALARY_CHNG_FLAG_CODE) ETCB_SALARY_CHNG_FLAG
, ETCB_PRFRTNG_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_PRFRTNG_CHNG_FLAG_CODE) ETCB_PRFRTNG_CHNG_FLAG
, ETCB_PERFBAND_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_PERFBAND_CHNG_FLAG_CODE) ETCB_PERFBAND_CHNG_FLAG
, ETCB_POWBAND_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_POWBAND_CHNG_FLAG_CODE) ETCB_POWBAND_CHNG_FLAG
, ETCB_HDC_GAIN_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_HDC_GAIN_FLAG_CODE) ETCB_HDC_GAIN_FLAG
, ETCB_HDC_LOSS_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_HDC_LOSS_FLAG_CODE) ETCB_HDC_LOSS_FLAG
, ETCB_HDC_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_HDC_CHNG_FLAG_CODE) ETCB_HDC_CHNG_FLAG
, ETCB_FTE_GAIN_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_FTE_GAIN_FLAG_CODE) ETCB_FTE_GAIN_FLAG
, ETCB_FTE_LOSS_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_FTE_LOSS_FLAG_CODE) ETCB_FTE_LOSS_FLAG
, ETCB_FTE_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_FTE_CHNG_FLAG_CODE) ETCB_FTE_CHNG_FLAG
, ETCB_GRD_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_GRD_CHNG_FLAG_CODE) ETCB_GRD_CHNG_FLAG
, ETCB_JOB_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_JOB_CHNG_FLAG_CODE) ETCB_JOB_CHNG_FLAG
, ETCB_POS_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_POS_CHNG_FLAG_CODE) ETCB_POS_CHNG_FLAG
, ETCB_LOC_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_LOC_CHNG_FLAG_CODE) ETCB_LOC_CHNG_FLAG
, ETCB_ORG_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_ORG_CHNG_FLAG_CODE) ETCB_ORG_CHNG_FLAG
, ETCB_MGRH_CHNG_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_MGRH_CHNG_FLAG_CODE) ETCB_MGRH_CHNG_FLAG
, ETCB_HIRE_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_HIRE_FLAG_CODE) ETCB_HIRE_FLAG
, ETCB_ASG_START_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_ASG_START_FLAG_CODE) ETCB_ASG_START_FLAG
, ETCB_HIRE_OR_START_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_HIRE_OR_START_FLAG_CODE) ETCB_HIRE_OR_START_FLAG
, ETCB_TERM_OR_END_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_TERM_OR_END_FLAG_CODE) ETCB_TERM_OR_END_FLAG
, ETCB_TERM_VOL_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_TERM_VOL_FLAG_CODE) ETCB_TERM_VOL_FLAG
, ETCB_TERM_INVOL_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_TERM_INVOL_FLAG_CODE) ETCB_TERM_INVOL_FLAG
, ETCB_TERM_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_TERM_FLAG_CODE) ETCB_TERM_FLAG
, ETCB_ASG_END_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_ASG_END_FLAG_CODE) ETCB_ASG_END_FLAG
, ETCB_START_SSPNSN_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_START_SSPNSN_FLAG_CODE) ETCB_START_SSPNSN_FLAG
, ETCB_END_SSPNSN_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_END_SSPNSN_FLAG_CODE) ETCB_END_SSPNSN_FLAG
, ETCB_PRMTN_FLAG_CODE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, ETCB_PRMTN_FLAG_CODE) ETCB_PRMTN_FLAG
FROM HRI_CL_WEVT_EVTYPCMB_CT