[Home] [Help]
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
Name |
DESC_TXT |
CM_TRGR_SRC_CD |
CM_TRGR_SRC_CD_M |
CM_TRGR_TYP_CD |
CM_TRGR_TYP_CD_M |
PROC_CD |
PROC_CD_M |
CM_TRGR_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |