[Home] [Help] [Dependency Information]

VIEW: APPS.BENBV_PER_ELIGIBILITY_V

Object Details

Object Name:	BENBV_PER_ELIGIBILITY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_PER_ELIGIBILITY_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

Query Text

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

SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PRTN_STRT_DT
,      PRTN_END_DT
,      PL_ORDR_NUM
,      PLIP_ORDR_NUM
,      PTIP_ORDR_NUM
,      OIPL_ORDR_NUM
,      PROGRAM_UPDATE_DATE
,      OVRID_SVC_DT
,      PRTN_OVRIDN_THRU_DT
,      AGE_VAL
,      AGE_UOM
,      AGE_UOM_M
,      LOS_VAL
,      LOS_UOM
,      LOS_UOM_M
,      RT_AGE_VAL
,      RT_AGE_UOM
,      RT_AGE_UOM_M
,      RT_LOS_VAL
,      RT_LOS_UOM
,      RT_LOS_UOM_M
,      COMP_REF_UOM
,      HRS_WKD_VAL
,      RT_COMP_REF_AMT
,      CMBN_AGE_N_LOS_VAL
,      COMP_REF_AMT
,      PCT_FL_TM_VAL
,      RT_CMBN_AGE_N_LOS_VAL
,      RT_COMP_REF_UOM
,      RT_HRS_WKD_VAL
,      RT_PCT_FL_TM_VAL
,      WAIT_PERD_STRT_DT
,      WAIT_PERD_CMPLTN_DT
,      HRS_WKD_BNDRY_PERD_CD
,      HRS_WKD_BNDRY_PERD_CD_M
,      WV_PRTN_RSN_CD
,      WV_PRTN_RSN_CD_M
,      PRTN_OVRIDN_RSN_CD
,      PRTN_OVRIDN_RSN_CD_M
,      WV_CTFN_TYP_CD
,      WV_CTFN_TYP_CD_M
,      RT_HRS_WKD_BNDRY_PERD_CD
,      RT_HRS_WKD_BNDRY_PERD_CD_M
,      INELG_RSN_CD
,      INELG_RSN_CD_M
,      ONCE_R_CNTUG_CD
,      ONCE_R_CNTUG_CD_M
,      DSTR_RSTCN_FLAG
,      DSTR_RSTCN_FLAG_M
,      DPNT_OTHR_PL_CVRD_RL_FLAG
,      DPNT_OTHR_PL_CVRD_RL_FLAG_M
,      PL_HGHLY_COMPD_FLAG
,      PL_HGHLY_COMPD_FLAG_M
,      PL_KEY_EE_FLAG
,      PL_KEY_EE_FLAG_M
,      ELIG_FLAG
,      ELIG_FLAG_M
,      PL_WVD_FLAG
,      PL_WVD_FLAG_M
,      PRTN_OVRIDN_FLAG
,      PRTN_OVRIDN_FLAG_M
,      NO_MX_PRTN_OVRID_THRU_FLAG
,      NO_MX_PRTN_OVRID_THRU_FLAG_M
,      FRZ_LOS_FLAG
,      FRZ_LOS_FLAG_M
,      FRZ_AGE_FLAG
,      FRZ_AGE_FLAG_M
,      FRZ_CMP_LVL_FLAG
,      FRZ_CMP_LVL_FLAG_M
,      FRZ_PCT_FL_TM_FLAG
,      FRZ_PCT_FL_TM_FLAG_M
,      FRZ_HRS_WKD_FLAG
,      FRZ_HRS_WKD_FLAG_M
,      FRZ_COMB_AGE_AND_LOS_FLAG
,      FRZ_COMB_AGE_AND_LOS_FLAG_M
,      RT_FRZ_LOS_FLAG
,      RT_FRZ_LOS_FLAG_M
,      RT_FRZ_AGE_FLAG
,      RT_FRZ_AGE_FLAG_M
,      RT_FRZ_CMP_LVL_FLAG
,      RT_FRZ_CMP_LVL_FLAG_M
,      RT_FRZ_PCT_FL_TM_FLAG
,      RT_FRZ_PCT_FL_TM_FLAG_M
,      RT_FRZ_HRS_WKD_FLAG
,      RT_FRZ_HRS_WKD_FLAG_M
,      RT_FRZ_COMB_AGE_AND_LOS_FLAG
,      RT_FRZ_COMB_AGE_AND_LOS_FLAG_M
,      PERSON_ID
,      ELIG_PER_ID
,      ELIG_PER_OPT_ID
,      BUSINESS_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PER_IN_LER_ID
,      PL_ID
,      PLIP_ID
,      PGM_ID
,      PTIP_ID
,      OPT_ID
,      LER_ID
,      MUST_ENRL_ANTHR_PL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.BENBV_PER_ELIGIBILITY_V;

Dependencies

[top of page]

APPS

BEN_ELIG_PER_F

BEN_ELIG_PER_OPT_F

HR_BIS - show dependent code

APPS.BENBV_PER_ELIGIBILITY_V is not referenced by any database object