eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BENBV_CM_DLVRY_MTHD_TYP_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the delivery mechanisms available to transmit compensation-related communications, for example, e-mail, voicemail, postal service and fax.
Implementation/DBA Data:	APPS.BENBV_CM_DLVRY_MTHD_TYP_V

View Text

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

Columns

Name
"_DF:CMT"
CM_DLVRY_MTHD_TYP_CD
CM_DLVRY_MTHD_TYP_CD_M
DFLT_FLAG
DFLT_FLAG_M
RQD_FLAG
RQD_FLAG_M
CM_DLVRY_MTHD_TYP_ID
BUSINESS_GROUP_ID
CM_TYP_ID
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY