VIEW: APPS.BENBV_CM_DLVRY_MED_TYP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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