eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.BENBV_ELIGY_PRFL_V

Object Details

Object Name:	BENBV_ELIGY_PRFL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_ELIGY_PRFL_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
NAME	VARCHAR2	(240)	Yes	Participant eligibility profile name.
DESCRIPTION	VARCHAR2	(2000)		Eligibility profile description.
_DF:ELP	CHAR	(28)
STAT_CD	VARCHAR2	(30)	Yes	Status (Lookup code based on lookup type BEN_STAT).
STAT_CD_M	VARCHAR2	(4000)		Status (Lookup meaning based on lookup type BEN_STAT).
ASG_TYP_CD	VARCHAR2	(30)		Assignment type (Lookup code based on lookup type BEN_ASGN_TYP).
ASG_TYP_CD_M	VARCHAR2	(4000)		Assignment type (Lookup meaning based on lookup type BEN_ASGN_TYP).
ASMT_TO_USE_CD	VARCHAR2	(30)		Assignment to use code (Lookup code based on lookup type BEN_ASMT_TO_USE).
ASMT_TO_USE_CD_M	VARCHAR2	(4000)		Assignment to use code (Lookup meaning based on lookup type BEN_ASMT_TO_USE).
BNFT_CAGR_PRTN_CD	VARCHAR2	(30)	Yes	Applies to (Lookup code based on lookup type BEN_BNFT_CAGR_PRTN).
BNFT_CAGR_PRTN_CD_M	VARCHAR2	(4000)		Applies to (Lookup meaning based on lookup type BEN_BNFT_CAGR_PRTN).
ELIG_ENRLD_PLIP_FLAG	VARCHAR2	(30)	Yes	Elig enrld plip flag m (Lookup code based on lookup type YES_NO).
ELIG_ENRLD_PLIP_FLAG_M	VARCHAR2	(4000)		Elig enrld plip flag m (Lookup meaning based on lookup type YES_NO).
ELIG_CBR_QUALD_BNF_FLAG	VARCHAR2	(30)	Yes	Elig cbr quald bnf flag m (Lookup code based on lookup type YES_NO).
ELIG_CBR_QUALD_BNF_FLAG_M	VARCHAR2	(4000)		Elig cbr quald bnf flag m (Lookup meaning based on lookup type YES_NO).
ELIG_ENRLD_PTIP_FLAG	VARCHAR2	(30)	Yes	Elig enrld ptip flag m (Lookup code based on lookup type YES_NO).
ELIG_ENRLD_PTIP_FLAG_M	VARCHAR2	(4000)		Elig enrld ptip flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DPNT_CVRD_PLIP_FLAG	VARCHAR2	(30)	Yes	Elig dpnt cvrd plip flag m (Lookup code based on lookup type YES_NO).
ELIG_DPNT_CVRD_PLIP_FLAG_M	VARCHAR2	(4000)		Elig dpnt cvrd plip flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DPNT_CVRD_PTIP_FLAG	VARCHAR2	(30)	Yes	Elig dpnt cvrd ptip flag m (Lookup code based on lookup type YES_NO).
ELIG_DPNT_CVRD_PTIP_FLAG_M	VARCHAR2	(4000)		Elig dpnt cvrd ptip flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DPNT_CVRD_PGM_FLAG	VARCHAR2	(30)	Yes	Elig dpnt cvrd pgm flag m (Lookup code based on lookup type YES_NO).
ELIG_DPNT_CVRD_PGM_FLAG_M	VARCHAR2	(4000)		Elig dpnt cvrd pgm flag m (Lookup meaning based on lookup type YES_NO).
ELIG_JOB_FLAG	VARCHAR2	(30)	Yes	Elig job flag m (Lookup code based on lookup type YES_NO).
ELIG_JOB_FLAG_M	VARCHAR2	(4000)		Elig job flag m (Lookup meaning based on lookup type YES_NO).
ELIG_HRLY_SLRD_FLAG	VARCHAR2	(30)	Yes	Elig hrly slrd flag m (Lookup code based on lookup type YES_NO).
ELIG_HRLY_SLRD_FLAG_M	VARCHAR2	(4000)		Elig hrly slrd flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PSTL_CD_FLAG	VARCHAR2	(30)	Yes	Elig pstl cd flag m (Lookup code based on lookup type YES_NO).
ELIG_PSTL_CD_FLAG_M	VARCHAR2	(4000)		Elig pstl cd flag m (Lookup meaning based on lookup type YES_NO).
ELIG_LBR_MMBR_FLAG	VARCHAR2	(30)	Yes	Elig lbr mmbr flag m (Lookup code based on lookup type YES_NO).
ELIG_LBR_MMBR_FLAG_M	VARCHAR2	(4000)		Elig lbr mmbr flag m (Lookup meaning based on lookup type YES_NO).
ELIG_LGL_ENTY_FLAG	VARCHAR2	(30)	Yes	Elig lgl enty flag m (Lookup code based on lookup type YES_NO).
ELIG_LGL_ENTY_FLAG_M	VARCHAR2	(4000)		Elig lgl enty flag m (Lookup meaning based on lookup type YES_NO).
ELIG_BENFTS_GRP_FLAG	VARCHAR2	(30)	Yes	Elig benfts grp flag m (Lookup code based on lookup type YES_NO).
ELIG_BENFTS_GRP_FLAG_M	VARCHAR2	(4000)		Elig benfts grp flag m (Lookup meaning based on lookup type YES_NO).
ELIG_WK_LOC_FLAG	VARCHAR2	(30)	Yes	Elig wk loc flag m (Lookup code based on lookup type YES_NO).
ELIG_WK_LOC_FLAG_M	VARCHAR2	(4000)		Elig wk loc flag m (Lookup meaning based on lookup type YES_NO).
ELIG_BRGNG_UNIT_FLAG	VARCHAR2	(30)	Yes	Elig brgng unit flag m (Lookup code based on lookup type YES_NO).
ELIG_BRGNG_UNIT_FLAG_M	VARCHAR2	(4000)		Elig brgng unit flag m (Lookup meaning based on lookup type YES_NO).
ELIG_AGE_FLAG	VARCHAR2	(30)	Yes	Elig age flag m (Lookup code based on lookup type YES_NO).
ELIG_AGE_FLAG_M	VARCHAR2	(4000)		Elig age flag m (Lookup meaning based on lookup type YES_NO).
ELIG_LOS_FLAG	VARCHAR2	(30)	Yes	Elig los flag m (Lookup code based on lookup type YES_NO).
ELIG_LOS_FLAG_M	VARCHAR2	(4000)		Elig los flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PER_TYP_FLAG	VARCHAR2	(30)	Yes	Elig per typ flag m (Lookup code based on lookup type YES_NO).
ELIG_PER_TYP_FLAG_M	VARCHAR2	(4000)		Elig per typ flag m (Lookup meaning based on lookup type YES_NO).
ELIG_FL_TM_PT_TM_FLAG	VARCHAR2	(30)	Yes	Elig fl tm pt tm flag m (Lookup code based on lookup type YES_NO).
ELIG_FL_TM_PT_TM_FLAG_M	VARCHAR2	(4000)		Elig fl tm pt tm flag m (Lookup meaning based on lookup type YES_NO).
ELIG_EE_STAT_FLAG	VARCHAR2	(30)	Yes	Elig ee stat flag m (Lookup code based on lookup type YES_NO).
ELIG_EE_STAT_FLAG_M	VARCHAR2	(4000)		Elig ee stat flag m (Lookup meaning based on lookup type YES_NO).
ELIG_GRD_FLAG	VARCHAR2	(30)	Yes	Elig grd flag m (Lookup code based on lookup type YES_NO).
ELIG_GRD_FLAG_M	VARCHAR2	(4000)		Elig grd flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PCT_FL_TM_FLAG	VARCHAR2	(30)	Yes	Elig pct fl tm flag m (Lookup code based on lookup type YES_NO).
ELIG_PCT_FL_TM_FLAG_M	VARCHAR2	(4000)		Elig pct fl tm flag m (Lookup meaning based on lookup type YES_NO).
ELIG_ASNT_SET_FLAG	VARCHAR2	(30)	Yes	Elig asnt set flag m (Lookup code based on lookup type YES_NO).
ELIG_ASNT_SET_FLAG_M	VARCHAR2	(4000)		Elig asnt set flag m (Lookup meaning based on lookup type YES_NO).
ELIG_HRS_WKD_FLAG	VARCHAR2	(30)	Yes	Elig hrs wkd flag m (Lookup code based on lookup type YES_NO).
ELIG_HRS_WKD_FLAG_M	VARCHAR2	(4000)		Elig hrs wkd flag m (Lookup meaning based on lookup type YES_NO).
ELIG_COMP_LVL_FLAG	VARCHAR2	(30)	Yes	Elig comp lvl flag m (Lookup code based on lookup type YES_NO).
ELIG_COMP_LVL_FLAG_M	VARCHAR2	(4000)		Elig comp lvl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_ORG_UNIT_FLAG	VARCHAR2	(30)	Yes	Elig org unit flag m (Lookup code based on lookup type YES_NO).
ELIG_ORG_UNIT_FLAG_M	VARCHAR2	(4000)		Elig org unit flag m (Lookup meaning based on lookup type YES_NO).
ELIG_LOA_RSN_FLAG	VARCHAR2	(30)	Yes	Elig loa rsn flag m (Lookup code based on lookup type YES_NO).
ELIG_LOA_RSN_FLAG_M	VARCHAR2	(4000)		Elig loa rsn flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PYRL_FLAG	VARCHAR2	(30)	Yes	Elig pyrl flag m (Lookup code based on lookup type YES_NO).
ELIG_PYRL_FLAG_M	VARCHAR2	(4000)		Elig pyrl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_SCHEDD_HRS_FLAG	VARCHAR2	(30)	Yes	Elig schedd hrs flag m (Lookup code based on lookup type YES_NO).
ELIG_SCHEDD_HRS_FLAG_M	VARCHAR2	(4000)		Elig schedd hrs flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PY_BSS_FLAG	VARCHAR2	(30)	Yes	Elig py bss flag m (Lookup code based on lookup type YES_NO).
ELIG_PY_BSS_FLAG_M	VARCHAR2	(4000)		Elig py bss flag m (Lookup meaning based on lookup type YES_NO).
ELIGY_PRFL_RL_FLAG	VARCHAR2	(30)	Yes	Eligy prfl rl flag m (Lookup code based on lookup type YES_NO).
ELIGY_PRFL_RL_FLAG_M	VARCHAR2	(4000)		Eligy prfl rl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_CMBN_AGE_LOS_FLAG	VARCHAR2	(30)	Yes	Elig cmbn age los flag m (Lookup code based on lookup type YES_NO).
ELIG_CMBN_AGE_LOS_FLAG_M	VARCHAR2	(4000)		Elig cmbn age los flag m (Lookup meaning based on lookup type YES_NO).
CNTNG_PRTN_ELIG_PRFL_FLAG	VARCHAR2	(30)	Yes	Cntng prtn elig prfl flag m (Lookup code based on lookup type YES_NO).
CNTNG_PRTN_ELIG_PRFL_FLAG_M	VARCHAR2	(4000)		Cntng prtn elig prfl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PRTT_PL_FLAG	VARCHAR2	(30)	Yes	Elig prtt pl flag m (Lookup code based on lookup type YES_NO).
ELIG_PRTT_PL_FLAG_M	VARCHAR2	(4000)		Elig prtt pl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PPL_GRP_FLAG	VARCHAR2	(30)	Yes	Elig ppl grp flag m (Lookup code based on lookup type YES_NO).
ELIG_PPL_GRP_FLAG_M	VARCHAR2	(4000)		Elig ppl grp flag m (Lookup meaning based on lookup type YES_NO).
ELIG_SVC_AREA_FLAG	VARCHAR2	(30)	Yes	Elig svc area flag m (Lookup code based on lookup type YES_NO).
ELIG_SVC_AREA_FLAG_M	VARCHAR2	(4000)		Elig svc area flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PTIP_PRTE_FLAG	VARCHAR2	(30)	Yes	Elig ptip prte flag m (Lookup code based on lookup type YES_NO).
ELIG_PTIP_PRTE_FLAG_M	VARCHAR2	(4000)		Elig ptip prte flag m (Lookup meaning based on lookup type YES_NO).
ELIG_NO_OTHR_CVG_FLAG	VARCHAR2	(30)	Yes	Elig no othr cvg flag m (Lookup code based on lookup type YES_NO).
ELIG_NO_OTHR_CVG_FLAG_M	VARCHAR2	(4000)		Elig no othr cvg flag m (Lookup meaning based on lookup type YES_NO).
ELIG_ENRLD_PL_FLAG	VARCHAR2	(30)	Yes	Elig enrld pl flag m (Lookup code based on lookup type YES_NO).
ELIG_ENRLD_PL_FLAG_M	VARCHAR2	(4000)		Elig enrld pl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_ENRLD_OIPL_FLAG	VARCHAR2	(30)	Yes	Elig enrld oipl flag m (Lookup code based on lookup type YES_NO).
ELIG_ENRLD_OIPL_FLAG_M	VARCHAR2	(4000)		Elig enrld oipl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_ENRLD_PGM_FLAG	VARCHAR2	(30)	Yes	Elig enrld pgm flag m (Lookup code based on lookup type YES_NO).
ELIG_ENRLD_PGM_FLAG_M	VARCHAR2	(4000)		Elig enrld pgm flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DPNT_CVRD_PL_FLAG	VARCHAR2	(30)	Yes	Elig dpnt cvrd pl flag m (Lookup code based on lookup type YES_NO).
ELIG_DPNT_CVRD_PL_FLAG_M	VARCHAR2	(4000)		Elig dpnt cvrd pl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_LVG_RSN_FLAG	VARCHAR2	(30)	Yes	Elig lvg rsn flag m (Lookup code based on lookup type YES_NO).
ELIG_LVG_RSN_FLAG_M	VARCHAR2	(4000)		Elig lvg rsn flag m (Lookup meaning based on lookup type YES_NO).
ELIG_OPTD_MDCR_FLAG	VARCHAR2	(30)	Yes	Elig optd mdcr flag m (Lookup code based on lookup type YES_NO).
ELIG_OPTD_MDCR_FLAG_M	VARCHAR2	(4000)		Elig optd mdcr flag m (Lookup meaning based on lookup type YES_NO).
ELIG_TBCO_USE_FLAG	VARCHAR2	(30)	Yes	Elig tbco use flag m (Lookup code based on lookup type YES_NO).
ELIG_TBCO_USE_FLAG_M	VARCHAR2	(4000)		Elig tbco use flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DPNT_OTHR_PTIP_FLAG	VARCHAR2	(30)	Yes	Elig dpnt othr ptip flag m (Lookup code based on lookup type YES_NO).
ELIG_DPNT_OTHR_PTIP_FLAG_M	VARCHAR2	(4000)		Elig dpnt othr ptip flag m (Lookup meaning based on lookup type YES_NO).
ELIG_GNDR_FLAG	VARCHAR2	(30)	Yes	Elig gndr flag m (Lookup code based on lookup type YES_NO).
ELIG_GNDR_FLAG_M	VARCHAR2	(4000)		Elig gndr flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DSBLTY_CTG_FLAG	VARCHAR2	(30)	Yes	Elig dsblty ctg flag m (Lookup code based on lookup type YES_NO).
ELIG_DSBLTY_CTG_FLAG_M	VARCHAR2	(4000)		Elig dsblty ctg flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DSBLTY_DGR_FLAG	VARCHAR2	(30)	Yes	Elig dsblty dgr flag m (Lookup code based on lookup type YES_NO).
ELIG_DSBLTY_DGR_FLAG_M	VARCHAR2	(4000)		Elig dsblty dgr flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DSBLTY_RSN_FLAG	VARCHAR2	(30)	Yes	Elig dsblty rsn flag m (Lookup code based on lookup type YES_NO).
ELIG_DSBLTY_RSN_FLAG_M	VARCHAR2	(4000)		Elig dsblty rsn flag m (Lookup meaning based on lookup type YES_NO).
ELIG_MRTL_STS_FLAG	VARCHAR2	(30)	Yes	Elig mrtl sts flag m (Lookup code based on lookup type YES_NO).
ELIG_MRTL_STS_FLAG_M	VARCHAR2	(4000)		Elig mrtl sts flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PRBTN_PERD_FLAG	VARCHAR2	(30)	Yes	Elig prbtn perd flag m (Lookup code based on lookup type YES_NO).
ELIG_PRBTN_PERD_FLAG_M	VARCHAR2	(4000)		Elig prbtn perd flag m (Lookup meaning based on lookup type YES_NO).
ELIG_SP_CLNG_PRG_PT_FLAG	VARCHAR2	(30)	Yes	Elig sp clng prg pt flag m (Lookup code based on lookup type YES_NO).
ELIG_SP_CLNG_PRG_PT_FLAG_M	VARCHAR2	(4000)		Elig sp clng prg pt flag m (Lookup meaning based on lookup type YES_NO).
ELIG_SUPPL_ROLE_FLAG	VARCHAR2	(30)	Yes	Elig suppl role flag m (Lookup code based on lookup type YES_NO).
ELIG_SUPPL_ROLE_FLAG_M	VARCHAR2	(4000)		Elig suppl role flag m (Lookup meaning based on lookup type YES_NO).
ELIG_QUAL_TITL_FLAG	VARCHAR2	(30)	Yes	Elig qual titl flag m (Lookup code based on lookup type YES_NO).
ELIG_QUAL_TITL_FLAG_M	VARCHAR2	(4000)		Elig qual titl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PSTN_FLAG	VARCHAR2	(30)	Yes	Elig pstn flag m (Lookup code based on lookup type YES_NO).
ELIG_PSTN_FLAG_M	VARCHAR2	(4000)		Elig pstn flag m (Lookup meaning based on lookup type YES_NO).
ELIG_ANTHR_PL_FLAG	VARCHAR2	(30)	Yes	Elig anthr pl flag m (Lookup code based on lookup type YES_NO).
ELIG_ANTHR_PL_FLAG_M	VARCHAR2	(4000)		Elig anthr pl flag m (Lookup meaning based on lookup type YES_NO).
ELIG_HLTH_CVG_FLAG	VARCHAR2	(30)	Yes	Elig hlth cvg flag m (Lookup code based on lookup type YES_NO).
ELIG_HLTH_CVG_FLAG_M	VARCHAR2	(4000)		Elig hlth cvg flag m (Lookup meaning based on lookup type YES_NO).
ELIG_DSBLD_FLAG	VARCHAR2	(30)	Yes	Elig dsbld flag m (Lookup code based on lookup type YES_NO).
ELIG_DSBLD_FLAG_M	VARCHAR2	(4000)		Elig dsbld flag m (Lookup meaning based on lookup type YES_NO).
ELIG_TTL_CVG_VOL_FLAG	VARCHAR2	(30)	Yes	Elig ttl cvg vol flag m (Lookup code based on lookup type YES_NO).
ELIG_TTL_CVG_VOL_FLAG_M	VARCHAR2	(4000)		Elig ttl cvg vol flag m (Lookup meaning based on lookup type YES_NO).
ELIG_TTL_PRTT_FLAG	VARCHAR2	(30)	Yes	Elig ttl prtt flag m (Lookup code based on lookup type YES_NO).
ELIG_TTL_PRTT_FLAG_M	VARCHAR2	(4000)		Elig ttl prtt flag m (Lookup meaning based on lookup type YES_NO).
ELIG_COMPTNCY_FLAG	VARCHAR2	(30)	Yes	Elig comptncy flag m (Lookup code based on lookup type YES_NO).
ELIG_COMPTNCY_FLAG_M	VARCHAR2	(4000)		Elig comptncy flag m (Lookup meaning based on lookup type YES_NO).
ELIG_QUA_IN_GR_FLAG	VARCHAR2	(30)	Yes	Elig qua in gr flag m (Lookup code based on lookup type YES_NO).
ELIG_QUA_IN_GR_FLAG_M	VARCHAR2	(4000)		Elig qua in gr flag m (Lookup meaning based on lookup type YES_NO).
ELIG_PERF_RTNG_FLAG	VARCHAR2	(30)	Yes	Elig perf rtng flag m (Lookup code based on lookup type YES_NO).
ELIG_PERF_RTNG_FLAG_M	VARCHAR2	(4000)		Elig perf rtng flag m (Lookup meaning based on lookup type YES_NO).
ELIGY_PRFL_ID	NUMBER	(15)	Yes	System generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      DESCRIPTION
,      _DF:ELP
,      STAT_CD
,      STAT_CD_M
,      ASG_TYP_CD
,      ASG_TYP_CD_M
,      ASMT_TO_USE_CD
,      ASMT_TO_USE_CD_M
,      BNFT_CAGR_PRTN_CD
,      BNFT_CAGR_PRTN_CD_M
,      ELIG_ENRLD_PLIP_FLAG
,      ELIG_ENRLD_PLIP_FLAG_M
,      ELIG_CBR_QUALD_BNF_FLAG
,      ELIG_CBR_QUALD_BNF_FLAG_M
,      ELIG_ENRLD_PTIP_FLAG
,      ELIG_ENRLD_PTIP_FLAG_M
,      ELIG_DPNT_CVRD_PLIP_FLAG
,      ELIG_DPNT_CVRD_PLIP_FLAG_M
,      ELIG_DPNT_CVRD_PTIP_FLAG
,      ELIG_DPNT_CVRD_PTIP_FLAG_M
,      ELIG_DPNT_CVRD_PGM_FLAG
,      ELIG_DPNT_CVRD_PGM_FLAG_M
,      ELIG_JOB_FLAG
,      ELIG_JOB_FLAG_M
,      ELIG_HRLY_SLRD_FLAG
,      ELIG_HRLY_SLRD_FLAG_M
,      ELIG_PSTL_CD_FLAG
,      ELIG_PSTL_CD_FLAG_M
,      ELIG_LBR_MMBR_FLAG
,      ELIG_LBR_MMBR_FLAG_M
,      ELIG_LGL_ENTY_FLAG
,      ELIG_LGL_ENTY_FLAG_M
,      ELIG_BENFTS_GRP_FLAG
,      ELIG_BENFTS_GRP_FLAG_M
,      ELIG_WK_LOC_FLAG
,      ELIG_WK_LOC_FLAG_M
,      ELIG_BRGNG_UNIT_FLAG
,      ELIG_BRGNG_UNIT_FLAG_M
,      ELIG_AGE_FLAG
,      ELIG_AGE_FLAG_M
,      ELIG_LOS_FLAG
,      ELIG_LOS_FLAG_M
,      ELIG_PER_TYP_FLAG
,      ELIG_PER_TYP_FLAG_M
,      ELIG_FL_TM_PT_TM_FLAG
,      ELIG_FL_TM_PT_TM_FLAG_M
,      ELIG_EE_STAT_FLAG
,      ELIG_EE_STAT_FLAG_M
,      ELIG_GRD_FLAG
,      ELIG_GRD_FLAG_M
,      ELIG_PCT_FL_TM_FLAG
,      ELIG_PCT_FL_TM_FLAG_M
,      ELIG_ASNT_SET_FLAG
,      ELIG_ASNT_SET_FLAG_M
,      ELIG_HRS_WKD_FLAG
,      ELIG_HRS_WKD_FLAG_M
,      ELIG_COMP_LVL_FLAG
,      ELIG_COMP_LVL_FLAG_M
,      ELIG_ORG_UNIT_FLAG
,      ELIG_ORG_UNIT_FLAG_M
,      ELIG_LOA_RSN_FLAG
,      ELIG_LOA_RSN_FLAG_M
,      ELIG_PYRL_FLAG
,      ELIG_PYRL_FLAG_M
,      ELIG_SCHEDD_HRS_FLAG
,      ELIG_SCHEDD_HRS_FLAG_M
,      ELIG_PY_BSS_FLAG
,      ELIG_PY_BSS_FLAG_M
,      ELIGY_PRFL_RL_FLAG
,      ELIGY_PRFL_RL_FLAG_M
,      ELIG_CMBN_AGE_LOS_FLAG
,      ELIG_CMBN_AGE_LOS_FLAG_M
,      CNTNG_PRTN_ELIG_PRFL_FLAG
,      CNTNG_PRTN_ELIG_PRFL_FLAG_M
,      ELIG_PRTT_PL_FLAG
,      ELIG_PRTT_PL_FLAG_M
,      ELIG_PPL_GRP_FLAG
,      ELIG_PPL_GRP_FLAG_M
,      ELIG_SVC_AREA_FLAG
,      ELIG_SVC_AREA_FLAG_M
,      ELIG_PTIP_PRTE_FLAG
,      ELIG_PTIP_PRTE_FLAG_M
,      ELIG_NO_OTHR_CVG_FLAG
,      ELIG_NO_OTHR_CVG_FLAG_M
,      ELIG_ENRLD_PL_FLAG
,      ELIG_ENRLD_PL_FLAG_M
,      ELIG_ENRLD_OIPL_FLAG
,      ELIG_ENRLD_OIPL_FLAG_M
,      ELIG_ENRLD_PGM_FLAG
,      ELIG_ENRLD_PGM_FLAG_M
,      ELIG_DPNT_CVRD_PL_FLAG
,      ELIG_DPNT_CVRD_PL_FLAG_M
,      ELIG_LVG_RSN_FLAG
,      ELIG_LVG_RSN_FLAG_M
,      ELIG_OPTD_MDCR_FLAG
,      ELIG_OPTD_MDCR_FLAG_M
,      ELIG_TBCO_USE_FLAG
,      ELIG_TBCO_USE_FLAG_M
,      ELIG_DPNT_OTHR_PTIP_FLAG
,      ELIG_DPNT_OTHR_PTIP_FLAG_M
,      ELIG_GNDR_FLAG
,      ELIG_GNDR_FLAG_M
,      ELIG_DSBLTY_CTG_FLAG
,      ELIG_DSBLTY_CTG_FLAG_M
,      ELIG_DSBLTY_DGR_FLAG
,      ELIG_DSBLTY_DGR_FLAG_M
,      ELIG_DSBLTY_RSN_FLAG
,      ELIG_DSBLTY_RSN_FLAG_M
,      ELIG_MRTL_STS_FLAG
,      ELIG_MRTL_STS_FLAG_M
,      ELIG_PRBTN_PERD_FLAG
,      ELIG_PRBTN_PERD_FLAG_M
,      ELIG_SP_CLNG_PRG_PT_FLAG
,      ELIG_SP_CLNG_PRG_PT_FLAG_M
,      ELIG_SUPPL_ROLE_FLAG
,      ELIG_SUPPL_ROLE_FLAG_M
,      ELIG_QUAL_TITL_FLAG
,      ELIG_QUAL_TITL_FLAG_M
,      ELIG_PSTN_FLAG
,      ELIG_PSTN_FLAG_M
,      ELIG_ANTHR_PL_FLAG
,      ELIG_ANTHR_PL_FLAG_M
,      ELIG_HLTH_CVG_FLAG
,      ELIG_HLTH_CVG_FLAG_M
,      ELIG_DSBLD_FLAG
,      ELIG_DSBLD_FLAG_M
,      ELIG_TTL_CVG_VOL_FLAG
,      ELIG_TTL_CVG_VOL_FLAG_M
,      ELIG_TTL_PRTT_FLAG
,      ELIG_TTL_PRTT_FLAG_M
,      ELIG_COMPTNCY_FLAG
,      ELIG_COMPTNCY_FLAG_M
,      ELIG_QUA_IN_GR_FLAG
,      ELIG_QUA_IN_GR_FLAG_M
,      ELIG_PERF_RTNG_FLAG
,      ELIG_PERF_RTNG_FLAG_M
,      ELIGY_PRFL_ID
,      BUSINESS_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_ELIGY_PRFL_V;

Dependencies

[top of page]

APPS.BENBV_ELIGY_PRFL_V references the following:

APPS: BEN_ELIGY_PRFL_F; HR_BIS - show dependent code

APPS.BENBV_ELIGY_PRFL_V is referenced by following:

PUBLIC: BENBV_ELIGY_PRFL_V