View: BENBV_CM_TRGR_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the instances available to trigger a communication for a person.
Implementation/DBA Data:	APPS.BENBV_CM_TRGR_V

View Text

SELECT CM.DESC_TXT
, /* CODES */ CM.CM_TRGR_SRC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_TRGR_SRC'
, CM.CM_TRGR_SRC_CD)
, CM.CM_TRGR_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_TRGR_TYP'
, CM.CM_TRGR_TYP_CD)
, CM.PROC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PROC'
, CM.PROC_CD)
, /* ID COLUMNS */ CM.CM_TRGR_ID
, /* WHO COLUMNS */ CM.LAST_UPDATE_DATE
, CM.LAST_UPDATED_BY
, CM.CREATED_BY
, CM.CREATION_DATE
FROM BEN_CM_TRGR CM WITH READ ONLY

Columns