VIEW: APPS.BENBV_OIPL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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