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_PRTT_ENRT_RSLT_V

Object Details

Object Name:	BENBV_PRTT_ENRT_RSLT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_PRTT_ENRT_RSLT_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.
ENRT_CVG_STRT_DT	DATE		Yes	Coverage start date.
ENRT_CVG_THRU_DT	DATE		Yes	Coverage end date.
PL_ORDR_NUM	NUMBER	(15)		Plan order number.
PLIP_ORDR_NUM	NUMBER	(15)		Plan in program order number.
PTIP_ORDR_NUM	NUMBER	(15)		Plan type in program order number.
OIPL_ORDR_NUM	NUMBER	(15)		Option in plan order number.
PROGRAM_UPDATE_DATE	DATE			Program update date.
BNFT_AMT	NUMBER			Coverage amount.
BNFT_NNMNTRY_UOM	VARCHAR2	(30)		Non-monetary uom (Lookup code based on lookup type BEN_NNMNTRY_UOM).
BNFT_NNMNTRY_UOM_M	VARCHAR2	(4000)		Non-monetary uom (Lookup meaning based on lookup type BEN_NNMNTRY_UOM).
UOM	VARCHAR2	(30)		Currency.
ORGNL_ENRT_DT	DATE			Original coverage start date.
ERLST_DEENRT_DT	DATE			Earliest coverage de-enrollment date.
ENRT_OVRID_THRU_DT	DATE			Enrollment override through date.
BNFT_ORDR_NUM	NUMBER	(15)		Benefit ordr num.
_DF:PEN	CHAR	(32)
ENRT_MTHD_CD	VARCHAR2	(30)	Yes	Enrollment method (Lookup code based on lookup type BEN_ENRT_RSLT_MTHD).
ENRT_MTHD_CD_M	VARCHAR2	(4000)		Enrollment method (Lookup meaning based on lookup type BEN_ENRT_RSLT_MTHD).
BNFT_TYP_CD	VARCHAR2	(30)		Benefit type (Lookup code based on lookup type BEN_BNFT_TYP).
BNFT_TYP_CD_M	VARCHAR2	(4000)		Benefit type (Lookup meaning based on lookup type BEN_BNFT_TYP).
ENRT_OVRID_RSN_CD	VARCHAR2	(30)		Enrollment override reason (Lookup code based on lookup type BEN_OVRID_RSN).
ENRT_OVRID_RSN_CD_M	VARCHAR2	(4000)		Enrollment override reason (Lookup meaning based on lookup type BEN_OVRID_RSN).
PRTT_ENRT_RSLT_STAT_CD	VARCHAR2	(30)		Enrollment result status (Lookup code based on lookup type BEN_PRTT_ENRT_RSLT_STAT).
PRTT_ENRT_RSLT_STAT_CD_M	VARCHAR2	(4000)		Enrollment result status (Lookup meaning based on lookup type BEN_PRTT_ENRT_RSLT_STAT).
COMP_LVL_CD	VARCHAR2	(30)		Enrollment level (Lookup code based on lookup type BEN_COMP_LVL).
COMP_LVL_CD_M	VARCHAR2	(4000)		Enrollment level (Lookup meaning based on lookup type BEN_COMP_LVL).
SSPNDD_FLAG	VARCHAR2	(30)	Yes	Suspended enrollment (Lookup code based on lookup type YES_NO).
SSPNDD_FLAG_M	VARCHAR2	(4000)		Suspended enrollment (Lookup meaning based on lookup type YES_NO).
PRTT_IS_CVRD_FLAG	VARCHAR2	(30)	Yes	Participant is covered (Lookup code based on lookup type YES_NO).
PRTT_IS_CVRD_FLAG_M	VARCHAR2	(4000)		Participant is covered (Lookup meaning based on lookup type YES_NO).
ENRT_OVRIDN_FLAG	VARCHAR2	(30)	Yes	Enrollment overriden (Lookup code based on lookup type YES_NO).
ENRT_OVRIDN_FLAG_M	VARCHAR2	(4000)		Enrollment overriden (Lookup meaning based on lookup type YES_NO).
NO_LNGR_ELIG_FLAG	VARCHAR2	(30)	Yes	Eligible for compensation object (Lookup code based on lookup type YES_NO).
NO_LNGR_ELIG_FLAG_M	VARCHAR2	(4000)		Eligible for compensation object (Lookup meaning based on lookup type YES_NO).
PRTT_ENRT_RSLT_ID	NUMBER	(15)	Yes	System generated primary key column.
PERSON_ID	NUMBER	(15)	Yes	Foreign Key to PER_ALL_PEOPLE_F.
PL_ID	NUMBER	(15)	Yes	Foreign key to BEN_PL_F.
LER_ID	NUMBER	(15)	Yes	Foreign key to BEN_LER_F.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PGM_ID	NUMBER	(15)		Foreign key to BEN_PGM_F.
PL_TYP_ID	NUMBER	(15)		Foreign key to BEN_PL_TYP_F.
OIPL_ID	NUMBER	(15)		Foreign key to BEN_OIPL_F.
PTIP_ID	NUMBER	(15)		Foreign key to BEN_PTIP_F.
PER_IN_LER_ID	NUMBER	(15)		Foreign key to BEN_PER_IN_LER.
ASSIGNMENT_ID	NUMBER	(15)		Foreign key to HR_ASSIGNMENT_SET_AMENDMENTS.
RPLCS_SSPNDD_RSLT_ID	NUMBER	(15)		Foreign key to BEN_PRTT_ENRT_RSLT_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
,      ENRT_CVG_STRT_DT
,      ENRT_CVG_THRU_DT
,      PL_ORDR_NUM
,      PLIP_ORDR_NUM
,      PTIP_ORDR_NUM
,      OIPL_ORDR_NUM
,      PROGRAM_UPDATE_DATE
,      BNFT_AMT
,      BNFT_NNMNTRY_UOM
,      BNFT_NNMNTRY_UOM_M
,      UOM
,      ORGNL_ENRT_DT
,      ERLST_DEENRT_DT
,      ENRT_OVRID_THRU_DT
,      BNFT_ORDR_NUM
,      _DF:PEN
,      ENRT_MTHD_CD
,      ENRT_MTHD_CD_M
,      BNFT_TYP_CD
,      BNFT_TYP_CD_M
,      ENRT_OVRID_RSN_CD
,      ENRT_OVRID_RSN_CD_M
,      PRTT_ENRT_RSLT_STAT_CD
,      PRTT_ENRT_RSLT_STAT_CD_M
,      COMP_LVL_CD
,      COMP_LVL_CD_M
,      SSPNDD_FLAG
,      SSPNDD_FLAG_M
,      PRTT_IS_CVRD_FLAG
,      PRTT_IS_CVRD_FLAG_M
,      ENRT_OVRIDN_FLAG
,      ENRT_OVRIDN_FLAG_M
,      NO_LNGR_ELIG_FLAG
,      NO_LNGR_ELIG_FLAG_M
,      PRTT_ENRT_RSLT_ID
,      PERSON_ID
,      PL_ID
,      LER_ID
,      BUSINESS_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PGM_ID
,      PL_TYP_ID
,      OIPL_ID
,      PTIP_ID
,      PER_IN_LER_ID
,      ASSIGNMENT_ID
,      RPLCS_SSPNDD_RSLT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_PRTT_ENRT_RSLT_V;

Dependencies

[top of page]

APPS.BENBV_PRTT_ENRT_RSLT_V references the following:

APPS: BEN_PRTT_ENRT_RSLT_F; HR_BIS - show dependent code

APPS.BENBV_PRTT_ENRT_RSLT_V is referenced by following:

PUBLIC: BENBV_PRTT_ENRT_RSLT_V