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

VIEW: APPS.BENBV_ELIG_TO_PRTE_RSN_V

Object Details
Object Name: BENBV_ELIG_TO_PRTE_RSN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_ELIG_TO_PRTE_RSN_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.
PRTN_EFF_STRT_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
PRTN_EFF_END_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
WAIT_PERD_UOM VARCHAR2 (30)
Waiting period unit of measure (Lookup code based on lookup type BEN_TM_UOM).
WAIT_PERD_UOM_M VARCHAR2 (4000)
Waiting period unit of measure (Lookup meaning based on lookup type BEN_TM_UOM).
WAIT_PERD_VAL NUMBER (15)
Waiting period value.
WAIT_PERD_DT_TO_USE_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_POE_UOM VARCHAR2 (30)
Maximum period of enrollment unit of measure (Lookup code based on lookup type BEN_RQD_PERD_ENRT_NENRT_TM_UOM).
MX_POE_UOM_M VARCHAR2 (4000)
Maximum period of enrollment unit of measure (Lookup meaning based on lookup type BEN_RQD_PERD_ENRT_NENRT_TM_UOM).
MX_POE_VAL NUMBER (15)
Maximum period of enrollment value.
MX_POE_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
WAIT_PERD_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_POE_DET_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
VRFY_FMLY_MMBR_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
_DF:PEO CHAR (34)
ELIG_INELIG_CD VARCHAR2 (30) Yes Eligible or ineligible code (Lookup code based on lookup type BEN_ELIG_INELIG).
ELIG_INELIG_CD_M VARCHAR2 (4000)
Eligible or ineligible code (Lookup meaning based on lookup type BEN_ELIG_INELIG).
PRTN_EFF_STRT_DT_CD VARCHAR2 (30)
Participation effective start date code (Lookup code based on lookup type BEN_PRTN_ELIG_STRT).
PRTN_EFF_STRT_DT_CD_M VARCHAR2 (4000)
Participation effective start date code (Lookup meaning based on lookup type BEN_PRTN_ELIG_STRT).
PRTN_EFF_END_DT_CD VARCHAR2 (30)
Participation effective end date code (Lookup code based on lookup type BEN_PRTN_ELIG_END).
PRTN_EFF_END_DT_CD_M VARCHAR2 (4000)
Participation effective end date code (Lookup meaning based on lookup type BEN_PRTN_ELIG_END).
WAIT_PERD_DT_TO_USE_CD VARCHAR2 (30)
Waiting period date to use code (Lookup code based on lookup type BEN_MX_WTG_DT_TO_USE).
WAIT_PERD_DT_TO_USE_CD_M VARCHAR2 (4000)
Waiting period date to use code (Lookup meaning based on lookup type BEN_MX_WTG_DT_TO_USE).
MX_POE_DET_DT_CD VARCHAR2 (30)
Maximum period of enrollment determination date code (Lookup code based on lookup type BEN_MX_POE_DET_DT).
MX_POE_DET_DT_CD_M VARCHAR2 (4000)
Maximum period of enrollment determination date code (Lookup meaning based on lookup type BEN_MX_POE_DET_DT).
MX_POE_APLS_CD VARCHAR2 (30)
Maximum period of enrollment applies to (Lookup code based on lookup type BEN_MX_POE_APLS).
MX_POE_APLS_CD_M VARCHAR2 (4000)
Maximum period of enrollment applies to (Lookup meaning based on lookup type BEN_MX_POE_APLS).
VRFY_FMLY_MMBR_CD VARCHAR2 (30)
Verify family member code (Lookup code based on lookup type BEN_FMLY_MMBR).
VRFY_FMLY_MMBR_CD_M VARCHAR2 (4000)
Verify family member code (Lookup meaning based on lookup type BEN_FMLY_MMBR).
PRTN_OVRIDBL_FLAG VARCHAR2 (30) Yes Participation overridable (Lookup code based on lookup type YES_NO).
PRTN_OVRIDBL_FLAG_M VARCHAR2 (4000)
Participation overridable (Lookup meaning based on lookup type YES_NO).
IGNR_PRTN_OVRID_FLAG VARCHAR2 (30) Yes Ignore participation override (Lookup code based on lookup type YES_NO).
IGNR_PRTN_OVRID_FLAG_M VARCHAR2 (4000)
Ignore participation override (Lookup meaning based on lookup type YES_NO).
ELIG_TO_PRTE_RSN_ID NUMBER (15) Yes System generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS.
LER_ID NUMBER (15) Yes Foreign key to BEN_LER_F.
PTIP_ID NUMBER (15)
Foreign key to BEN_PTIP_F.
PLIP_ID NUMBER (15)
Foreign key to BEN_PLIP_F.
OIPL_ID NUMBER (15)
Foreign key to BEN_OIPL_F.
PL_ID NUMBER (15)
Foreign key to BEN_PL_F.
PGM_ID NUMBER (15)
Foreign key to BEN_PGM_F.
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
,      PRTN_EFF_STRT_DT_RL
,      PRTN_EFF_END_DT_RL
,      WAIT_PERD_UOM
,      WAIT_PERD_UOM_M
,      WAIT_PERD_VAL
,      WAIT_PERD_DT_TO_USE_RL
,      MX_POE_UOM
,      MX_POE_UOM_M
,      MX_POE_VAL
,      MX_POE_RL
,      WAIT_PERD_RL
,      MX_POE_DET_DT_RL
,      VRFY_FMLY_MMBR_RL
,      _DF:PEO
,      ELIG_INELIG_CD
,      ELIG_INELIG_CD_M
,      PRTN_EFF_STRT_DT_CD
,      PRTN_EFF_STRT_DT_CD_M
,      PRTN_EFF_END_DT_CD
,      PRTN_EFF_END_DT_CD_M
,      WAIT_PERD_DT_TO_USE_CD
,      WAIT_PERD_DT_TO_USE_CD_M
,      MX_POE_DET_DT_CD
,      MX_POE_DET_DT_CD_M
,      MX_POE_APLS_CD
,      MX_POE_APLS_CD_M
,      VRFY_FMLY_MMBR_CD
,      VRFY_FMLY_MMBR_CD_M
,      PRTN_OVRIDBL_FLAG
,      PRTN_OVRIDBL_FLAG_M
,      IGNR_PRTN_OVRID_FLAG
,      IGNR_PRTN_OVRID_FLAG_M
,      ELIG_TO_PRTE_RSN_ID
,      BUSINESS_GROUP_ID
,      LER_ID
,      PTIP_ID
,      PLIP_ID
,      OIPL_ID
,      PL_ID
,      PGM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_ELIG_TO_PRTE_RSN_V;

Dependencies

[top of page]

APPS.BENBV_ELIG_TO_PRTE_RSN_V references the following:

SchemaAPPS
SynonymBEN_ELIG_TO_PRTE_RSN_F
PL/SQL PackageHR_BIS - show dependent code

APPS.BENBV_ELIG_TO_PRTE_RSN_V is not referenced by any database object