VIEW: APPS.BEN_OIPL

Source

View Text - Preformatted

SELECT 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.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 WHERE cop.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) AND cop.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT 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.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
WHERE COP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND COP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))