[Home] [Help] [Dependency Information]

VIEW: APPS.BEN_BNFT_PRVDR_POOL_D

Object Details

Object Name:	BEN_BNFT_PRVDR_POOL_D
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BEN_BNFT_PRVDR_POOL_D
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 ROW_ID
,      BNFT_PRVDR_POOL_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      PROGRAM_POOL_MEANING
,      EXCESS_ALWYS_FORFEITED_MEANING
,      USE_FOR_PROGRAM_POOL_MEANING
,      PERCENT_ROUNDING_MEANING
,      VALUE_ROUNDING_MEANING
,      PLAN_IN_PROGRAM_NAME
,      PLAN_TYPE_IN_PROGRAM_NAME
,      DEFAULT_EXCESS_TREATMNT
,      DEFAULT_EXCESS_TREATMENT_NAME
,      ROLLOVER_RESTRICTION_MEANING
,      NO_MIN_EXCESS_PERCENT
,      NO_MIN_EXCESS_VALUE
,      NO_MAX_EXCESS_PERCENT
,      NO_MAX_EXCESS_VALUE
,      MIN_EXCESS_PERCENT
,      MIN_EXCESS_AMOUNT
,      MAX_EXCESS_PERCENT
,      MAX_EXCESS_AMOUNT
,      EXCESS_TREATMENT_MEANING
,      AUTO_ALCT_EXCS_MEANING
,      PROGRAM_NAME
,      PERCENT_ROUNDING_NAME
,      VALUE_ROUNDING_NAME
,      OPTION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.BEN_BNFT_PRVDR_POOL_D;

Dependencies

[top of page]

APPS

BEN_BNFT_PRVDR_POOL_F

BEN_OIPLIP_F

BEN_OIPL_F

BEN_OPT_F

BEN_PGM_F

BEN_PLIP_F

BEN_PL_F

BEN_PL_TYP_F

BEN_PTIP_F

FF_FORMULAS_F

FND_GLOBAL - show dependent code

FND_USER_VIEW

HR_API - show dependent code

HR_LOOKUPS

PUBLIC

BEN_BNFT_PRVDR_POOL_D