Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PTIP |
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'))