VIEW: APPS.BEN_BACK_OUT_ENRT_RSLT_V

Source

View Text - Preformatted

SELECT PEN.PRTT_ENRT_RSLT_ID , PEN.EFFECTIVE_START_DATE , PEN.EFFECTIVE_END_DATE , PEN.BUSINESS_GROUP_ID , PEN.OIPL_ID , PEN.PERSON_ID , PEN.ASSIGNMENT_ID , PEN.PGM_ID , PEN.PL_ID , PEN.RPLCS_SSPNDD_RSLT_ID , PEN.PTIP_ID , PEN.PL_TYP_ID , PEN.LER_ID , PEN.SSPNDD_FLAG , PEN.PRTT_IS_CVRD_FLAG , PEN.BNFT_AMT , PEN.UOM , PEN.ORGNL_ENRT_DT , PEN.ENRT_MTHD_CD , PEN.NO_LNGR_ELIG_FLAG , PEN.ENRT_OVRIDN_FLAG , PEN.ENRT_OVRID_RSN_CD , PEN.ERLST_DEENRT_DT , PEN.ENRT_CVG_STRT_DT , PEN.ENRT_CVG_THRU_DT , PEN.ENRT_OVRID_THRU_DT , 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.PER_IN_LER_ID , PEN.BNFT_TYP_CD , PEN.BNFT_NNMNTRY_UOM , PEN.COMP_LVL_CD , PEN.BNFT_ORDR_NUM , PEN.PRTT_ENRT_RSLT_STAT_CD , PEN.PL_ORDR_NUM , PEN.PLIP_ORDR_NUM , PEN.PTIP_ORDR_NUM , PEN.OIPL_ORDR_NUM FROM BEN_PRTT_ENRT_RSLT_F PEN UNION SELECT LCR.BKUP_TBL_ID , LCR.EFFECTIVE_START_DATE , LCR.EFFECTIVE_END_DATE , LCR.BUSINESS_GROUP_ID , LCR.OIPL_ID , LCR.PERSON_ID , LCR.ASSIGNMENT_ID , LCR.PGM_ID , LCR.PL_ID , LCR.RPLCS_SSPNDD_RSLT_ID , LCR.PTIP_ID , LCR.PL_TYP_ID , LCR.LER_ID , LCR.SSPNDD_FLAG , LCR.PRTT_IS_CVRD_FLAG , LCR.BNFT_AMT , LCR.UOM , LCR.ORGNL_ENRT_DT , LCR.ENRT_MTHD_CD , LCR.NO_LNGR_ELIG_FLAG , LCR.ENRT_OVRIDN_FLAG , LCR.ENRT_OVRID_RSN_CD , LCR.ERLST_DEENRT_DT , LCR.ENRT_CVG_STRT_DT , LCR.ENRT_CVG_THRU_DT , LCR.ENRT_OVRID_THRU_DT , LCR.LCR_ATTRIBUTE_CATEGORY , LCR.LCR_ATTRIBUTE1 , LCR.LCR_ATTRIBUTE2 , LCR.LCR_ATTRIBUTE3 , LCR.LCR_ATTRIBUTE4 , LCR.LCR_ATTRIBUTE5 , LCR.LCR_ATTRIBUTE6 , LCR.LCR_ATTRIBUTE7 , LCR.LCR_ATTRIBUTE8 , LCR.LCR_ATTRIBUTE9 , LCR.LCR_ATTRIBUTE10 , LCR.LCR_ATTRIBUTE11 , LCR.LCR_ATTRIBUTE12 , LCR.LCR_ATTRIBUTE13 , LCR.LCR_ATTRIBUTE14 , LCR.LCR_ATTRIBUTE15 , LCR.LCR_ATTRIBUTE16 , LCR.LCR_ATTRIBUTE17 , LCR.LCR_ATTRIBUTE18 , LCR.LCR_ATTRIBUTE19 , LCR.LCR_ATTRIBUTE20 , LCR.LCR_ATTRIBUTE21 , LCR.LCR_ATTRIBUTE22 , LCR.LCR_ATTRIBUTE23 , LCR.LCR_ATTRIBUTE24 , LCR.LCR_ATTRIBUTE25 , LCR.LCR_ATTRIBUTE26 , LCR.LCR_ATTRIBUTE27 , LCR.LCR_ATTRIBUTE28 , LCR.LCR_ATTRIBUTE29 , LCR.LCR_ATTRIBUTE30 , LCR.LAST_UPDATE_DATE , LCR.LAST_UPDATED_BY , LCR.LAST_UPDATE_LOGIN , LCR.CREATED_BY , LCR.CREATION_DATE , LCR.REQUEST_ID , LCR.PROGRAM_APPLICATION_ID , LCR.PROGRAM_ID , LCR.PROGRAM_UPDATE_DATE , LCR.OBJECT_VERSION_NUMBER , LCR.PER_IN_LER_ID , LCR.BNFT_TYP_CD , LCR.BNFT_NNMNTRY_UOM , LCR.COMP_LVL_CD , LCR.BNFT_ORDR_NUM , LCR.PRTT_ENRT_RSLT_STAT_CD , LCR.PL_ORDR_NUM , LCR.PLIP_ORDR_NUM , LCR.PTIP_ORDR_NUM , LCR.OIPL_ORDR_NUM FROM BEN_LE_CLSN_N_RSTR LCR WHERE LCR.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F'

View Text - HTML Formatted

SELECT PEN.PRTT_ENRT_RSLT_ID
, PEN.EFFECTIVE_START_DATE
, PEN.EFFECTIVE_END_DATE
, PEN.BUSINESS_GROUP_ID
, PEN.OIPL_ID
, PEN.PERSON_ID
, PEN.ASSIGNMENT_ID
, PEN.PGM_ID
, PEN.PL_ID
, PEN.RPLCS_SSPNDD_RSLT_ID
, PEN.PTIP_ID
, PEN.PL_TYP_ID
, PEN.LER_ID
, PEN.SSPNDD_FLAG
, PEN.PRTT_IS_CVRD_FLAG
, PEN.BNFT_AMT
, PEN.UOM
, PEN.ORGNL_ENRT_DT
, PEN.ENRT_MTHD_CD
, PEN.NO_LNGR_ELIG_FLAG
, PEN.ENRT_OVRIDN_FLAG
, PEN.ENRT_OVRID_RSN_CD
, PEN.ERLST_DEENRT_DT
, PEN.ENRT_CVG_STRT_DT
, PEN.ENRT_CVG_THRU_DT
, PEN.ENRT_OVRID_THRU_DT
, 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.PER_IN_LER_ID
, PEN.BNFT_TYP_CD
, PEN.BNFT_NNMNTRY_UOM
, PEN.COMP_LVL_CD
, PEN.BNFT_ORDR_NUM
, PEN.PRTT_ENRT_RSLT_STAT_CD
, PEN.PL_ORDR_NUM
, PEN.PLIP_ORDR_NUM
, PEN.PTIP_ORDR_NUM
, PEN.OIPL_ORDR_NUM
FROM BEN_PRTT_ENRT_RSLT_F PEN UNION SELECT LCR.BKUP_TBL_ID
, LCR.EFFECTIVE_START_DATE
, LCR.EFFECTIVE_END_DATE
, LCR.BUSINESS_GROUP_ID
, LCR.OIPL_ID
, LCR.PERSON_ID
, LCR.ASSIGNMENT_ID
, LCR.PGM_ID
, LCR.PL_ID
, LCR.RPLCS_SSPNDD_RSLT_ID
, LCR.PTIP_ID
, LCR.PL_TYP_ID
, LCR.LER_ID
, LCR.SSPNDD_FLAG
, LCR.PRTT_IS_CVRD_FLAG
, LCR.BNFT_AMT
, LCR.UOM
, LCR.ORGNL_ENRT_DT
, LCR.ENRT_MTHD_CD
, LCR.NO_LNGR_ELIG_FLAG
, LCR.ENRT_OVRIDN_FLAG
, LCR.ENRT_OVRID_RSN_CD
, LCR.ERLST_DEENRT_DT
, LCR.ENRT_CVG_STRT_DT
, LCR.ENRT_CVG_THRU_DT
, LCR.ENRT_OVRID_THRU_DT
, LCR.LCR_ATTRIBUTE_CATEGORY
, LCR.LCR_ATTRIBUTE1
, LCR.LCR_ATTRIBUTE2
, LCR.LCR_ATTRIBUTE3
, LCR.LCR_ATTRIBUTE4
, LCR.LCR_ATTRIBUTE5
, LCR.LCR_ATTRIBUTE6
, LCR.LCR_ATTRIBUTE7
, LCR.LCR_ATTRIBUTE8
, LCR.LCR_ATTRIBUTE9
, LCR.LCR_ATTRIBUTE10
, LCR.LCR_ATTRIBUTE11
, LCR.LCR_ATTRIBUTE12
, LCR.LCR_ATTRIBUTE13
, LCR.LCR_ATTRIBUTE14
, LCR.LCR_ATTRIBUTE15
, LCR.LCR_ATTRIBUTE16
, LCR.LCR_ATTRIBUTE17
, LCR.LCR_ATTRIBUTE18
, LCR.LCR_ATTRIBUTE19
, LCR.LCR_ATTRIBUTE20
, LCR.LCR_ATTRIBUTE21
, LCR.LCR_ATTRIBUTE22
, LCR.LCR_ATTRIBUTE23
, LCR.LCR_ATTRIBUTE24
, LCR.LCR_ATTRIBUTE25
, LCR.LCR_ATTRIBUTE26
, LCR.LCR_ATTRIBUTE27
, LCR.LCR_ATTRIBUTE28
, LCR.LCR_ATTRIBUTE29
, LCR.LCR_ATTRIBUTE30
, LCR.LAST_UPDATE_DATE
, LCR.LAST_UPDATED_BY
, LCR.LAST_UPDATE_LOGIN
, LCR.CREATED_BY
, LCR.CREATION_DATE
, LCR.REQUEST_ID
, LCR.PROGRAM_APPLICATION_ID
, LCR.PROGRAM_ID
, LCR.PROGRAM_UPDATE_DATE
, LCR.OBJECT_VERSION_NUMBER
, LCR.PER_IN_LER_ID
, LCR.BNFT_TYP_CD
, LCR.BNFT_NNMNTRY_UOM
, LCR.COMP_LVL_CD
, LCR.BNFT_ORDR_NUM
, LCR.PRTT_ENRT_RSLT_STAT_CD
, LCR.PL_ORDR_NUM
, LCR.PLIP_ORDR_NUM
, LCR.PTIP_ORDR_NUM
, LCR.OIPL_ORDR_NUM
FROM BEN_LE_CLSN_N_RSTR LCR
WHERE LCR.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F'