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_OIPL_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the processing characteristics of an option that is provided by a plan.
Implementation/DBA Data:	APPS.BENBV_OIPL_V

View Text

SELECT COP.EFFECTIVE_START_DATE
, COP.EFFECTIVE_END_DATE
, COP.IVR_IDENT
, COP.ORDR_NUM
, COP.AUTO_ENRT_MTHD_RL
, COP.DFLT_ENRT_DET_RL
, COP.RQD_PERD_ENRT_NENRT_UOM
, COP.RQD_PERD_ENRT_NENRT_VAL
, COP.RQD_PERD_ENRT_NENRT_RL
, COP.MNDTRY_RL
, COP.POSTELCN_EDIT_RL
, COP.VRFY_FMLY_MMBR_RL
, COP.URL_REF_NAME
, COP.ENRT_RL
, COP.SHORT_CODE
, COP.SHORT_NAME
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_OIPL_F:COP'
, /* CODES */ COP.OIPL_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT'
, COP.OIPL_STAT_CD)
, COP.DFLT_ENRT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DFLT_ENRT'
, COP.DFLT_ENRT_CD)
, COP.PER_CVRD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_CVRD'
, COP.PER_CVRD_CD)
, COP.VRFY_FMLY_MMBR_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_FMLY_MMBR'
, COP.VRFY_FMLY_MMBR_CD)
, COP.ENRT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT'
, COP.ENRT_CD)
, COP.PCP_DSGN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PCP_DSGN'
, COP.PCP_DSGN_CD)
, COP.PCP_DPNT_DSGN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PCP_DSGN'
, COP.PCP_DPNT_DSGN_CD)
, COP.MNDTRY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.MNDTRY_FLAG)
, COP.DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.DFLT_FLAG)
, COP.ELIG_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.ELIG_APLS_FLAG)
, COP.TRK_INELIG_PER_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.TRK_INELIG_PER_FLAG)
, COP.DRVBL_FCTR_PRTN_ELIG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.DRVBL_FCTR_PRTN_ELIG_FLAG)
, COP.PRTN_ELIG_OVRID_ALWD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.PRTN_ELIG_OVRID_ALWD_FLAG)
, COP.DRVBL_FCTR_APLS_RTS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.DRVBL_FCTR_APLS_RTS_FLAG)
, COP.AUTO_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.AUTO_ENRT_FLAG)
, COP.HIDDEN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, COP.HIDDEN_FLAG)
, /* ID COLUMNS */ COP.OIPL_ID
, COP.PL_ID
, COP.OPT_ID
, COP.BUSINESS_GROUP_ID
, COP.ACTL_PREM_ID
, COP.LEGISLATION_CODE
, COP.LEGISLATION_SUBGROUP
, /* WHO COLUMNS */ COP.LAST_UPDATE_DATE
, COP.LAST_UPDATED_BY
, COP.CREATED_BY
, COP.CREATION_DATE
FROM BEN_OIPL_F COP
WHERE COP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, COP.BUSINESS_GROUP_ID) WITH READ ONLY

Columns

Name
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
IVR_IDENT
ORDR_NUM
AUTO_ENRT_MTHD_RL
DFLT_ENRT_DET_RL
RQD_PERD_ENRT_NENRT_UOM
RQD_PERD_ENRT_NENRT_VAL
RQD_PERD_ENRT_NENRT_RL
MNDTRY_RL
POSTELCN_EDIT_RL
VRFY_FMLY_MMBR_RL
URL_REF_NAME
ENRT_RL
SHORT_CODE
SHORT_NAME
"_DF:COP"
OIPL_STAT_CD
OIPL_STAT_CD_M
DFLT_ENRT_CD
DFLT_ENRT_CD_M
PER_CVRD_CD
PER_CVRD_CD_M
VRFY_FMLY_MMBR_CD
VRFY_FMLY_MMBR_CD_M
ENRT_CD
ENRT_CD_M
PCP_DSGN_CD
PCP_DSGN_CD_M
PCP_DPNT_DSGN_CD
PCP_DPNT_DSGN_CD_M
MNDTRY_FLAG
MNDTRY_FLAG_M
DFLT_FLAG
DFLT_FLAG_M
ELIG_APLS_FLAG
ELIG_APLS_FLAG_M
TRK_INELIG_PER_FLAG
TRK_INELIG_PER_FLAG_M
DRVBL_FCTR_PRTN_ELIG_FLAG
DRVBL_FCTR_PRTN_ELIG_FLAG_M
PRTN_ELIG_OVRID_ALWD_FLAG
PRTN_ELIG_OVRID_ALWD_FLAG_M
DRVBL_FCTR_APLS_RTS_FLAG
DRVBL_FCTR_APLS_RTS_FLAG_M
AUTO_ENRT_FLAG
AUTO_ENRT_FLAG_M
HIDDEN_FLAG
HIDDEN_FLAG_M
OIPL_ID
PL_ID
OPT_ID
BUSINESS_GROUP_ID
ACTL_PREM_ID
LEGISLATION_CODE
LEGISLATION_SUBGROUP
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE