VIEW: APPS.BENBV_CM_DLVRY_MTHD_TYP_V

Source

View Text - Preformatted

SELECT /* descriptive flexfield */ '_DF:BEN:BEN_CM_DLVRY_MTHD_TYP:CMT', /* codes */ CMT.CM_DLVRY_MTHD_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MTHD',CMT.CM_DLVRY_MTHD_TYP_CD), CMT.DFLT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CMT.DFLT_FLAG), CMT.RQD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CMT.RQD_FLAG), /* id columns */ CMT.CM_DLVRY_MTHD_TYP_ID, CMT.BUSINESS_GROUP_ID, CMT.CM_TYP_ID, /* who columns */ CMT.CREATED_BY, CMT.CREATION_DATE, CMT.LAST_UPDATE_DATE, CMT.LAST_UPDATED_BY FROM BEN_CM_DLVRY_MTHD_TYP CMT WHERE CMT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CMT.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CM_DLVRY_MTHD_TYP:CMT'
, /* CODES */ CMT.CM_DLVRY_MTHD_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DLVRY_MTHD'
, CMT.CM_DLVRY_MTHD_TYP_CD)
, CMT.DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CMT.DFLT_FLAG)
, CMT.RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CMT.RQD_FLAG)
, /* ID COLUMNS */ CMT.CM_DLVRY_MTHD_TYP_ID
, CMT.BUSINESS_GROUP_ID
, CMT.CM_TYP_ID
, /* WHO COLUMNS */ CMT.CREATED_BY
, CMT.CREATION_DATE
, CMT.LAST_UPDATE_DATE
, CMT.LAST_UPDATED_BY
FROM BEN_CM_DLVRY_MTHD_TYP CMT
WHERE CMT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CMT.BUSINESS_GROUP_ID) WITH READ ONLY