View: BENBV_CM_TYP_V

Product:	BEN - Advanced Benefits
Description:	This view identifies all communications provided to persons by the plan sponsor.
Implementation/DBA Data:	APPS.BENBV_CM_TYP_V

View Text

SELECT CCT.EFFECTIVE_START_DATE
, CCT.EFFECTIVE_END_DATE
, TL.NAME
, CCT.DESC_TXT
, CCT.SHRT_NAME
, CCT.CM_TYP_RL
, CCT.MX_NUM_AVLBL_VAL
, CCT.INSPN_RQD_RL
, CCT.TO_BE_SENT_DT_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CM_TYP_F:CCT'
, /* CODES */ CCT.TO_BE_SENT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TO_BE_SENT_DT'
, CCT.TO_BE_SENT_DT_CD)
, CCT.RCPENT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RCPENT'
, CCT.RCPENT_CD)
, CCT.CM_USG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_USG'
, CCT.CM_USG_CD)
, CCT.PC_KIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PC_KIT'
, CCT.PC_KIT_CD)
, CCT.WHNVR_TRGRD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCT.WHNVR_TRGRD_FLAG)
, CCT.TRK_MLG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCT.TRK_MLG_FLAG)
, CCT.INSPN_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCT.INSPN_RQD_FLAG)
, /* ID COLUMNS */ CCT.CM_TYP_ID
, CCT.BUSINESS_GROUP_ID
, CCT.PARNT_CM_TYP_ID
, /* WHO COLUMNS */ CCT.LAST_UPDATE_DATE
, CCT.LAST_UPDATED_BY
, CCT.CREATED_BY
, CCT.CREATION_DATE
FROM BEN_CM_TYP_F CCT
, BEN_CM_TYP_F_TL TL
WHERE CCT.CM_TYP_ID = TL.CM_TYP_ID
AND CCT.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE
AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns