VIEW: APPS.BEN_PRTT_ENRT_RSLT_X

Source

View Text - Preformatted

SELECT pen.PRTT_ENRT_RSLT_ID ,pen.EFFECTIVE_START_DATE ,pen.EFFECTIVE_END_DATE ,pen.ENRT_CVG_STRT_DT ,pen.ENRT_CVG_THRU_DT ,pen.SSPNDD_FLAG ,pen.PRTT_IS_CVRD_FLAG ,pen.BNFT_AMT ,pen.BNFT_NNMNTRY_UOM , PEN.COMP_LVL_CD, pen.BNFT_TYP_CD ,pen.UOM ,pen.ORGNL_ENRT_DT ,pen.ENRT_MTHD_CD ,pen.ENRT_OVRIDN_FLAG ,pen.ENRT_OVRID_RSN_CD ,pen.ERLST_DEENRT_DT ,pen.ENRT_OVRID_THRU_DT ,pen.PERSON_ID ,pen.ASSIGNMENT_ID ,pen.PGM_ID ,pen.PL_ID ,pen.OIPL_ID ,pen.PTIP_ID ,pen.PL_TYP_ID ,pen.LER_ID ,pen.PER_IN_LER_ID ,pen.RPLCS_SSPNDD_RSLT_ID ,pen.BUSINESS_GROUP_ID ,pen.PEN_ATTRIBUTE_CATEGORY ,pen.PEN_ATTRIBUTE1 ,pen.PEN_ATTRIBUTE2 ,pen.PEN_ATTRIBUTE3 ,pen.PEN_ATTRIBUTE4 ,pen.PEN_ATTRIBUTE5 ,pen.PEN_ATTRIBUTE6 ,pen.PEN_ATTRIBUTE7 ,pen.PEN_ATTRIBUTE8 ,pen.PEN_ATTRIBUTE9 ,pen.PEN_ATTRIBUTE10 ,pen.PEN_ATTRIBUTE11 ,pen.PEN_ATTRIBUTE12 ,pen.PEN_ATTRIBUTE13 ,pen.PEN_ATTRIBUTE14 ,pen.PEN_ATTRIBUTE15 ,pen.PEN_ATTRIBUTE16 ,pen.PEN_ATTRIBUTE17 ,pen.PEN_ATTRIBUTE18 ,pen.PEN_ATTRIBUTE19 ,pen.PEN_ATTRIBUTE20 ,pen.PEN_ATTRIBUTE21 ,pen.PEN_ATTRIBUTE22 ,pen.PEN_ATTRIBUTE23 ,pen.PEN_ATTRIBUTE24 ,pen.PEN_ATTRIBUTE25 ,pen.PEN_ATTRIBUTE26 ,pen.PEN_ATTRIBUTE27 ,pen.PEN_ATTRIBUTE28 ,pen.PEN_ATTRIBUTE29 ,pen.PEN_ATTRIBUTE30 ,pen.LAST_UPDATE_DATE ,pen.LAST_UPDATED_BY ,pen.LAST_UPDATE_LOGIN ,pen.CREATED_BY ,pen.CREATION_DATE ,pen.REQUEST_ID ,pen.PROGRAM_APPLICATION_ID ,pen.PROGRAM_ID ,pen.PROGRAM_UPDATE_DATE ,pen.OBJECT_VERSION_NUMBER ,pen.NO_LNGR_ELIG_FLAG ,pen.BNFT_ORDR_NUM ,pen.PRTT_ENRT_RSLT_STAT_CD from BEN_PRTT_ENRT_RSLT_F pen WHERE trunc(sysdate) between pen.effective_start_date and pen.effective_end_date

View Text - HTML Formatted

SELECT PEN.PRTT_ENRT_RSLT_ID
, PEN.EFFECTIVE_START_DATE
, PEN.EFFECTIVE_END_DATE
, PEN.ENRT_CVG_STRT_DT
, PEN.ENRT_CVG_THRU_DT
, PEN.SSPNDD_FLAG
, PEN.PRTT_IS_CVRD_FLAG
, PEN.BNFT_AMT
, PEN.BNFT_NNMNTRY_UOM
, PEN.COMP_LVL_CD
, PEN.BNFT_TYP_CD
, PEN.UOM
, PEN.ORGNL_ENRT_DT
, PEN.ENRT_MTHD_CD
, PEN.ENRT_OVRIDN_FLAG
, PEN.ENRT_OVRID_RSN_CD
, PEN.ERLST_DEENRT_DT
, PEN.ENRT_OVRID_THRU_DT
, PEN.PERSON_ID
, PEN.ASSIGNMENT_ID
, PEN.PGM_ID
, PEN.PL_ID
, PEN.OIPL_ID
, PEN.PTIP_ID
, PEN.PL_TYP_ID
, PEN.LER_ID
, PEN.PER_IN_LER_ID
, PEN.RPLCS_SSPNDD_RSLT_ID
, PEN.BUSINESS_GROUP_ID
, PEN.PEN_ATTRIBUTE_CATEGORY
, PEN.PEN_ATTRIBUTE1
, PEN.PEN_ATTRIBUTE2
, PEN.PEN_ATTRIBUTE3
, PEN.PEN_ATTRIBUTE4
, PEN.PEN_ATTRIBUTE5
, PEN.PEN_ATTRIBUTE6
, PEN.PEN_ATTRIBUTE7
, PEN.PEN_ATTRIBUTE8
, PEN.PEN_ATTRIBUTE9
, PEN.PEN_ATTRIBUTE10
, PEN.PEN_ATTRIBUTE11
, PEN.PEN_ATTRIBUTE12
, PEN.PEN_ATTRIBUTE13
, PEN.PEN_ATTRIBUTE14
, PEN.PEN_ATTRIBUTE15
, PEN.PEN_ATTRIBUTE16
, PEN.PEN_ATTRIBUTE17
, PEN.PEN_ATTRIBUTE18
, PEN.PEN_ATTRIBUTE19
, PEN.PEN_ATTRIBUTE20
, PEN.PEN_ATTRIBUTE21
, PEN.PEN_ATTRIBUTE22
, PEN.PEN_ATTRIBUTE23
, PEN.PEN_ATTRIBUTE24
, PEN.PEN_ATTRIBUTE25
, PEN.PEN_ATTRIBUTE26
, PEN.PEN_ATTRIBUTE27
, PEN.PEN_ATTRIBUTE28
, PEN.PEN_ATTRIBUTE29
, PEN.PEN_ATTRIBUTE30
, PEN.LAST_UPDATE_DATE
, PEN.LAST_UPDATED_BY
, PEN.LAST_UPDATE_LOGIN
, PEN.CREATED_BY
, PEN.CREATION_DATE
, PEN.REQUEST_ID
, PEN.PROGRAM_APPLICATION_ID
, PEN.PROGRAM_ID
, PEN.PROGRAM_UPDATE_DATE
, PEN.OBJECT_VERSION_NUMBER
, PEN.NO_LNGR_ELIG_FLAG
, PEN.BNFT_ORDR_NUM
, PEN.PRTT_ENRT_RSLT_STAT_CD
FROM BEN_PRTT_ENRT_RSLT_F PEN
WHERE TRUNC(SYSDATE) BETWEEN PEN.EFFECTIVE_START_DATE
AND PEN.EFFECTIVE_END_DATE