View: BEN_ELIGY_PRFL_V

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_ELIGY_PRFL_V

View Text

SELECT ELP.ROWID ROW_ID
, ELP.ELIGY_PRFL_ID
, ELP.EFFECTIVE_START_DATE
, ELP.EFFECTIVE_END_DATE
, ELP.NAME
, ELP.DESCRIPTION
, ELP.STAT_CD
, ELP.ASMT_TO_USE_CD
, ELP.BUSINESS_GROUP_ID
, ELP.ELP_ATTRIBUTE_CATEGORY
, ELP.ELP_ATTRIBUTE1
, ELP.ELP_ATTRIBUTE2
, ELP.ELP_ATTRIBUTE3
, ELP.ELP_ATTRIBUTE4
, ELP.ELP_ATTRIBUTE5
, ELP.ELP_ATTRIBUTE6
, ELP.ELP_ATTRIBUTE7
, ELP.ELP_ATTRIBUTE8
, ELP.ELP_ATTRIBUTE9
, ELP.ELP_ATTRIBUTE10
, ELP.ELP_ATTRIBUTE11
, ELP.ELP_ATTRIBUTE12
, ELP.ELP_ATTRIBUTE13
, ELP.ELP_ATTRIBUTE14
, ELP.ELP_ATTRIBUTE15
, ELP.ELP_ATTRIBUTE16
, ELP.ELP_ATTRIBUTE17
, ELP.ELP_ATTRIBUTE18
, ELP.ELP_ATTRIBUTE19
, ELP.ELP_ATTRIBUTE20
, ELP.ELP_ATTRIBUTE21
, ELP.ELP_ATTRIBUTE22
, ELP.ELP_ATTRIBUTE23
, ELP.ELP_ATTRIBUTE24
, ELP.ELP_ATTRIBUTE25
, ELP.ELP_ATTRIBUTE26
, ELP.ELP_ATTRIBUTE27
, ELP.ELP_ATTRIBUTE28
, ELP.ELP_ATTRIBUTE29
, ELP.ELP_ATTRIBUTE30
, ELP.LAST_UPDATE_DATE
, ELP.LAST_UPDATED_BY
, ELP.LAST_UPDATE_LOGIN
, ELP.CREATED_BY
, ELP.CREATION_DATE
, ELP.OBJECT_VERSION_NUMBER
, ELP.ELIG_ENRLD_PLIP_FLAG
, ELP.ELIG_CBR_QUALD_BNF_FLAG
, ELP.ELIG_ENRLD_PTIP_FLAG
, ELP.ELIG_DPNT_CVRD_PLIP_FLAG
, ELP.ELIG_DPNT_CVRD_PTIP_FLAG
, ELP.ELIG_DPNT_CVRD_PGM_FLAG
, ELP.ELIG_JOB_FLAG
, ELP.ELIG_HRLY_SLRD_FLAG
, ELP.ELIG_PSTL_CD_FLAG
, ELP.ELIG_LBR_MMBR_FLAG
, ELP.ELIG_LGL_ENTY_FLAG
, ELP.ELIG_BENFTS_GRP_FLAG
, ELP.ELIG_WK_LOC_FLAG
, ELP.ELIG_BRGNG_UNIT_FLAG
, ELP.ELIG_AGE_FLAG
, ELP.ELIG_LOS_FLAG
, ELP.ELIG_PER_TYP_FLAG
, ELP.ELIG_FL_TM_PT_TM_FLAG
, ELP.ELIG_EE_STAT_FLAG
, ELP.ELIG_GRD_FLAG
, ELP.ELIG_PCT_FL_TM_FLAG
, ELP.ELIG_ASNT_SET_FLAG
, ELP.ELIG_HRS_WKD_FLAG
, ELP.ELIG_COMP_LVL_FLAG
, ELP.ELIG_ORG_UNIT_FLAG
, ELP.ELIG_LOA_RSN_FLAG
, ELP.ELIG_PYRL_FLAG
, ELP.ELIG_SCHEDD_HRS_FLAG
, ELP.ELIG_PY_BSS_FLAG
, ELP.ELIGY_PRFL_RL_FLAG
, ELP.ELIG_CMBN_AGE_LOS_FLAG
, ELP.CNTNG_PRTN_ELIG_PRFL_FLAG
, ELP.ELIG_PRTT_PL_FLAG
, ELP.ELIG_PPL_GRP_FLAG
, ELP.ELIG_SVC_AREA_FLAG
, ELP.ELIG_PTIP_PRTE_FLAG
, ELP.ELIG_NO_OTHR_CVG_FLAG
, ELP.ELIG_ENRLD_PL_FLAG
, ELP.ELIG_ENRLD_OIPL_FLAG
, ELP.ELIG_ENRLD_PGM_FLAG
, ELP.ELIG_DPNT_CVRD_PL_FLAG
, ELP.ELIG_LVG_RSN_FLAG
, ELP.ELIG_OPTD_MDCR_FLAG
, ELP.ELIG_TBCO_USE_FLAG
, ELP.BNFT_CAGR_PRTN_CD
, ELP.ELIG_GNDR_FLAG
, ELP.ELIG_MRTL_STS_FLAG
, ELP.ELIG_DSBLTY_CTG_FLAG
, ELP.ELIG_DSBLTY_RSN_FLAG
, ELP.ELIG_DSBLTY_DGR_FLAG
, ELP.ELIG_SUPPL_ROLE_FLAG
, ELP.ELIG_QUAL_TITL_FLAG
, ELP.ELIG_PSTN_FLAG
, ELP.ELIG_PRBTN_PERD_FLAG
, ELP.ELIG_SP_CLNG_PRG_PT_FLAG
, ELP.ASG_TYP_CD
, ELP.ELIG_DPNT_OTHR_PTIP_FLAG
, ELP.ELIG_ANTHR_PL_FLAG
, ELP.ELIG_HLTH_CVG_FLAG
, ELP.ELIG_DSBLD_FLAG
, ELP.ELIG_TTL_CVG_VOL_FLAG
, ELP.ELIG_TTL_PRTT_FLAG
, ELP.ELIG_COMPTNCY_FLAG
, ELP.ELIG_QUA_IN_GR_FLAG
, ELP.ELIG_PERF_RTNG_FLAG
, ELP.ELIG_CRIT_VALUES_FLAG
FROM BEN_ELIGY_PRFL_F ELP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ELP.EFFECTIVE_START_DATE
AND ELP.EFFECTIVE_END_DATE

Columns