View: BENBV_CM_DLVRY_MED_TYP_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the material used to create the communication.
Implementation/DBA Data:	APPS.BENBV_CM_DLVRY_MED_TYP_V

View Text

SELECT /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CM_DLVRY_MED_TYP:CMD'
, /* CODES */ CMD.CM_DLVRY_MED_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MED'
, CMD.CM_DLVRY_MED_TYP_CD)
, CMD.RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CMD.RQD_FLAG)
, CMD.DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CMD.DFLT_FLAG)
, /* ID COLUMNS */ CMD.CM_DLVRY_MED_TYP_ID
, CMD.BUSINESS_GROUP_ID
, CMD.CM_DLVRY_MTHD_TYP_ID
, /* WHO COLUMNS */ CMD.LAST_UPDATE_DATE
, CMD.LAST_UPDATED_BY
, CMD.CREATED_BY
, CMD.CREATION_DATE
FROM BEN_CM_DLVRY_MED_TYP CMD
WHERE CMD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CMD.BUSINESS_GROUP_ID) WITH READ ONLY

Columns