View: BEN_OIPL_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_OIPL_V

View Text

SELECT COP.ROWID ROW_ID
, COP.OIPL_ID
, COP.EFFECTIVE_START_DATE
, COP.EFFECTIVE_END_DATE
, COP.IVR_IDENT
, COP.URL_REF_NAME
, COP.ORDR_NUM
, COP.MNDTRY_FLAG
, COP.DFLT_FLAG
, COP.OIPL_STAT_CD
, COP.ELIG_APLS_FLAG
, COP.DFLT_ENRT_DET_RL
, COP.TRK_INELIG_PER_FLAG
, COP.DRVBL_FCTR_PRTN_ELIG_FLAG
, COP.MNDTRY_RL
, COP.DFLT_ENRT_CD
, COP.PRTN_ELIG_OVRID_ALWD_FLAG
, COP.DRVBL_FCTR_APLS_RTS_FLAG
, COP.PER_CVRD_CD
, COP.POSTELCN_EDIT_RL
, COP.VRFY_FMLY_MMBR_CD
, COP.VRFY_FMLY_MMBR_RL
, COP.AUTO_ENRT_FLAG
, COP.AUTO_ENRT_MTHD_RL
, COP.ENRT_CD
, COP.ENRT_RL
, COP.OPT_ID
, COP.PL_ID
, COP.ACTL_PREM_ID
, COP.BUSINESS_GROUP_ID
, COP.SUSP_IF_CTFN_NOT_PRVD_FLAG
, COP.CTFN_DETERMINE_CD
, COP.COP_ATTRIBUTE_CATEGORY
, COP.COP_ATTRIBUTE1
, COP.COP_ATTRIBUTE2
, COP.COP_ATTRIBUTE3
, COP.COP_ATTRIBUTE4
, COP.COP_ATTRIBUTE5
, COP.COP_ATTRIBUTE6
, COP.COP_ATTRIBUTE7
, COP.COP_ATTRIBUTE8
, COP.COP_ATTRIBUTE9
, COP.COP_ATTRIBUTE10
, COP.COP_ATTRIBUTE11
, COP.COP_ATTRIBUTE12
, COP.COP_ATTRIBUTE13
, COP.COP_ATTRIBUTE14
, COP.COP_ATTRIBUTE15
, COP.COP_ATTRIBUTE16
, COP.COP_ATTRIBUTE17
, COP.COP_ATTRIBUTE18
, COP.COP_ATTRIBUTE19
, COP.COP_ATTRIBUTE20
, COP.COP_ATTRIBUTE21
, COP.COP_ATTRIBUTE22
, COP.COP_ATTRIBUTE23
, COP.COP_ATTRIBUTE24
, COP.COP_ATTRIBUTE25
, COP.COP_ATTRIBUTE26
, COP.COP_ATTRIBUTE27
, COP.COP_ATTRIBUTE28
, COP.COP_ATTRIBUTE29
, COP.COP_ATTRIBUTE30
, COP.LAST_UPDATE_DATE
, COP.LAST_UPDATED_BY
, COP.LAST_UPDATE_LOGIN
, COP.CREATED_BY
, COP.CREATION_DATE
, COP.OBJECT_VERSION_NUMBER
, COP.RQD_PERD_ENRT_NENRT_UOM
, COP.RQD_PERD_ENRT_NENRT_VAL
, COP.RQD_PERD_ENRT_NENRT_RL
, COP.PCP_DSGN_CD
, COP.PCP_DPNT_DSGN_CD
, COP.SHORT_NAME
, COP.SHORT_CODE
, COP.HIDDEN_FLAG
, COP.LEGISLATION_CODE
, COP.LEGISLATION_SUBGROUP
FROM BEN_OIPL_F COP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN COP.EFFECTIVE_START_DATE
AND COP.EFFECTIVE_END_DATE

Columns