VIEW: APPS.BEN_PTIP

Source

View Text - Preformatted

SELECT ctp.PTIP_ID ,ctp.EFFECTIVE_START_DATE ,ctp.EFFECTIVE_END_DATE ,ctp.COORD_CVG_FOR_ALL_PLS_FLAG ,ctp.DPNT_DSGN_CD ,ctp.DPNT_CVG_NO_CTFN_RQD_FLAG ,ctp.DPNT_CVG_STRT_DT_CD ,ctp.DPNT_CVG_STRT_DT_RL ,ctp.DPNT_CVG_END_DT_CD ,ctp.DPNT_CVG_END_DT_RL ,ctp.DPNT_ADRS_RQD_FLAG ,ctp.DPNT_LEGV_ID_RQD_FLAG ,ctp.POSTELCN_EDIT_RL ,ctp.DPNT_DOB_RQD_FLAG ,ctp.CRS_THIS_PL_TYP_ONLY_FLAG ,ctp.PTIP_STAT_CD ,ctp.MX_CVG_ALWD_AMT ,ctp.MX_ENRD_ALWD_OVRID_NUM ,ctp.MN_ENRD_RQD_OVRID_NUM ,ctp.NO_MX_PL_TYP_OVRID_FLAG ,ctp.ORDR_NUM ,ctp.PRVDS_CR_FLAG ,ctp.RQD_PERD_ENRT_NENRT_VAL ,ctp.RQD_PERD_ENRT_NENRT_TM_UOM ,ctp.WVBL_FLAG ,ctp.DRVD_FCTR_DPNT_CVG_FLAG ,ctp.NO_MN_PL_TYP_OVERID_FLAG ,ctp.SBJ_TO_SPS_LF_INS_MX_FLAG ,ctp.SBJ_TO_DPNT_LF_INS_MX_FLAG ,ctp.USE_TO_SUM_EE_LF_INS_FLAG ,ctp.RQD_ENRT_PERD_TCO_CD ,ctp.AUTO_ENRT_MTHD_RL ,ctp.ENRT_MTHD_CD ,ctp.ENRT_CD ,ctp.ENRT_RL ,ctp.DFLT_ENRT_CD ,ctp.DFLT_ENRT_DET_RL ,ctp.DRVBL_FCTR_APLS_RTS_FLAG ,ctp.DRVBL_FCTR_PRTN_ELIG_FLAG ,ctp.ELIG_APLS_FLAG ,ctp.PRTN_ELIG_OVRID_ALWD_FLAG ,ctp.TRK_INELIG_PER_FLAG ,ctp.PGM_ID ,ctp.PL_TYP_ID ,ctp.CMBN_PTIP_ID ,ctp.CMBN_PTIP_OPT_ID ,ctp.ACRS_PTIP_CVG_ID ,ctp.BUSINESS_GROUP_ID ,ctp.CTP_ATTRIBUTE_CATEGORY ,ctp.CTP_ATTRIBUTE1 ,ctp.CTP_ATTRIBUTE2 ,ctp.CTP_ATTRIBUTE3 ,ctp.CTP_ATTRIBUTE4 ,ctp.CTP_ATTRIBUTE5 ,ctp.CTP_ATTRIBUTE6 ,ctp.CTP_ATTRIBUTE7 ,ctp.CTP_ATTRIBUTE8 ,ctp.CTP_ATTRIBUTE9 ,ctp.CTP_ATTRIBUTE10 ,ctp.CTP_ATTRIBUTE11 ,ctp.CTP_ATTRIBUTE12 ,ctp.CTP_ATTRIBUTE13 ,ctp.CTP_ATTRIBUTE14 ,ctp.CTP_ATTRIBUTE15 ,ctp.CTP_ATTRIBUTE16 ,ctp.CTP_ATTRIBUTE17 ,ctp.CTP_ATTRIBUTE18 ,ctp.CTP_ATTRIBUTE19 ,ctp.CTP_ATTRIBUTE20 ,ctp.CTP_ATTRIBUTE21 ,ctp.CTP_ATTRIBUTE22 ,ctp.CTP_ATTRIBUTE23 ,ctp.CTP_ATTRIBUTE24 ,ctp.CTP_ATTRIBUTE25 ,ctp.CTP_ATTRIBUTE26 ,ctp.CTP_ATTRIBUTE27 ,ctp.CTP_ATTRIBUTE28 ,ctp.CTP_ATTRIBUTE29 ,ctp.CTP_ATTRIBUTE30 ,ctp.LAST_UPDATE_DATE ,ctp.LAST_UPDATED_BY ,ctp.LAST_UPDATE_LOGIN ,ctp.CREATED_BY ,ctp.CREATION_DATE ,ctp.OBJECT_VERSION_NUMBER ,ctp.IVR_IDENT ,ctp.URL_REF_NAME ,ctp.ENRT_CVG_STRT_DT_CD ,ctp.ENRT_CVG_STRT_DT_RL ,ctp.ENRT_CVG_END_DT_CD ,ctp.ENRT_CVG_END_DT_RL ,ctp.RT_STRT_DT_CD ,ctp.RT_STRT_DT_RL ,ctp.RT_END_DT_CD ,ctp.RT_END_DT_RL ,ctp.RQD_PERD_ENRT_NENRT_RL ,ctp.vrfy_fmly_mmbr_cd ,ctp.vrfy_fmly_mmbr_rl ,ctp.per_cvrd_cd ,ctp.SHORT_NAME ,ctp.SHORT_CODE ,ctp.LEGISLATION_CODE ,ctp.LEGISLATION_SUBGROUP from BEN_PTIP_F ctp WHERE ctp.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and ctp.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT CTP.PTIP_ID
, CTP.EFFECTIVE_START_DATE
, CTP.EFFECTIVE_END_DATE
, CTP.COORD_CVG_FOR_ALL_PLS_FLAG
, CTP.DPNT_DSGN_CD
, CTP.DPNT_CVG_NO_CTFN_RQD_FLAG
, CTP.DPNT_CVG_STRT_DT_CD
, CTP.DPNT_CVG_STRT_DT_RL
, CTP.DPNT_CVG_END_DT_CD
, CTP.DPNT_CVG_END_DT_RL
, CTP.DPNT_ADRS_RQD_FLAG
, CTP.DPNT_LEGV_ID_RQD_FLAG
, CTP.POSTELCN_EDIT_RL
, CTP.DPNT_DOB_RQD_FLAG
, CTP.CRS_THIS_PL_TYP_ONLY_FLAG
, CTP.PTIP_STAT_CD
, CTP.MX_CVG_ALWD_AMT
, CTP.MX_ENRD_ALWD_OVRID_NUM
, CTP.MN_ENRD_RQD_OVRID_NUM
, CTP.NO_MX_PL_TYP_OVRID_FLAG
, CTP.ORDR_NUM
, CTP.PRVDS_CR_FLAG
, CTP.RQD_PERD_ENRT_NENRT_VAL
, CTP.RQD_PERD_ENRT_NENRT_TM_UOM
, CTP.WVBL_FLAG
, CTP.DRVD_FCTR_DPNT_CVG_FLAG
, CTP.NO_MN_PL_TYP_OVERID_FLAG
, CTP.SBJ_TO_SPS_LF_INS_MX_FLAG
, CTP.SBJ_TO_DPNT_LF_INS_MX_FLAG
, CTP.USE_TO_SUM_EE_LF_INS_FLAG
, CTP.RQD_ENRT_PERD_TCO_CD
, CTP.AUTO_ENRT_MTHD_RL
, CTP.ENRT_MTHD_CD
, CTP.ENRT_CD
, CTP.ENRT_RL
, CTP.DFLT_ENRT_CD
, CTP.DFLT_ENRT_DET_RL
, CTP.DRVBL_FCTR_APLS_RTS_FLAG
, CTP.DRVBL_FCTR_PRTN_ELIG_FLAG
, CTP.ELIG_APLS_FLAG
, CTP.PRTN_ELIG_OVRID_ALWD_FLAG
, CTP.TRK_INELIG_PER_FLAG
, CTP.PGM_ID
, CTP.PL_TYP_ID
, CTP.CMBN_PTIP_ID
, CTP.CMBN_PTIP_OPT_ID
, CTP.ACRS_PTIP_CVG_ID
, CTP.BUSINESS_GROUP_ID
, CTP.CTP_ATTRIBUTE_CATEGORY
, CTP.CTP_ATTRIBUTE1
, CTP.CTP_ATTRIBUTE2
, CTP.CTP_ATTRIBUTE3
, CTP.CTP_ATTRIBUTE4
, CTP.CTP_ATTRIBUTE5
, CTP.CTP_ATTRIBUTE6
, CTP.CTP_ATTRIBUTE7
, CTP.CTP_ATTRIBUTE8
, CTP.CTP_ATTRIBUTE9
, CTP.CTP_ATTRIBUTE10
, CTP.CTP_ATTRIBUTE11
, CTP.CTP_ATTRIBUTE12
, CTP.CTP_ATTRIBUTE13
, CTP.CTP_ATTRIBUTE14
, CTP.CTP_ATTRIBUTE15
, CTP.CTP_ATTRIBUTE16
, CTP.CTP_ATTRIBUTE17
, CTP.CTP_ATTRIBUTE18
, CTP.CTP_ATTRIBUTE19
, CTP.CTP_ATTRIBUTE20
, CTP.CTP_ATTRIBUTE21
, CTP.CTP_ATTRIBUTE22
, CTP.CTP_ATTRIBUTE23
, CTP.CTP_ATTRIBUTE24
, CTP.CTP_ATTRIBUTE25
, CTP.CTP_ATTRIBUTE26
, CTP.CTP_ATTRIBUTE27
, CTP.CTP_ATTRIBUTE28
, CTP.CTP_ATTRIBUTE29
, CTP.CTP_ATTRIBUTE30
, CTP.LAST_UPDATE_DATE
, CTP.LAST_UPDATED_BY
, CTP.LAST_UPDATE_LOGIN
, CTP.CREATED_BY
, CTP.CREATION_DATE
, CTP.OBJECT_VERSION_NUMBER
, CTP.IVR_IDENT
, CTP.URL_REF_NAME
, CTP.ENRT_CVG_STRT_DT_CD
, CTP.ENRT_CVG_STRT_DT_RL
, CTP.ENRT_CVG_END_DT_CD
, CTP.ENRT_CVG_END_DT_RL
, CTP.RT_STRT_DT_CD
, CTP.RT_STRT_DT_RL
, CTP.RT_END_DT_CD
, CTP.RT_END_DT_RL
, CTP.RQD_PERD_ENRT_NENRT_RL
, CTP.VRFY_FMLY_MMBR_CD
, CTP.VRFY_FMLY_MMBR_RL
, CTP.PER_CVRD_CD
, CTP.SHORT_NAME
, CTP.SHORT_CODE
, CTP.LEGISLATION_CODE
, CTP.LEGISLATION_SUBGROUP
FROM BEN_PTIP_F CTP
WHERE CTP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CTP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))