[Home] [Help] [Dependency Information]
Object Name: | BEN_CVG_AMT_CALC_MTHD_D |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BEN_CVG_AMT_CALC_MTHD_D |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CVG_AMT_CALC_MTHD_ID | NUMBER | (15) | Yes | |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
COVERAGE_NAME | VARCHAR2 | (240) | Yes | |
INCREMENT_VALUE | NUMBER | |||
MAXIMUM_VALUE | NUMBER | |||
MINIMUM_VALUE | NUMBER | |||
NO_MAXIMUM_VALUE | VARCHAR2 | (80) | ||
NO_MINIMUM_VALUE | VARCHAR2 | (80) | ||
ROUNDING_CODE | VARCHAR2 | (80) | ||
ROUNDING_RULE | VARCHAR2 | (80) | ||
VALUE | NUMBER | |||
VALUE_OVERRIDE_ALLOWED | VARCHAR2 | (80) | ||
VALUE_RULE | VARCHAR2 | (80) | ||
UNIT_OF_MEASURE | VARCHAR2 | (30) | ||
NONMONETARY | VARCHAR2 | (80) | ||
BOUNDARY_PERIOD | VARCHAR2 | (80) | ||
BENEFIT_TYPE | VARCHAR2 | (80) | ||
COVERAGE_MULTIPLE | VARCHAR2 | (80) | ||
RATE_TYPE | VARCHAR2 | (80) | ||
DEFAULT_VALUE | NUMBER | |||
ENTER_VALUE_AT_ENROLLMENT | VARCHAR2 | (80) | ||
DEFAULT_FLAG | VARCHAR2 | (80) | ||
LOWER_LIMIT_VALUE | NUMBER | |||
LOWER_LIMIT_VALUE_RULE | VARCHAR2 | (80) | ||
UPPER_LIMIT_VALUE | NUMBER | |||
UPPER_LIMIT_VALUE_RULE | VARCHAR2 | (80) | ||
COMPENSATION_LEVEL_FACTOR | VARCHAR2 | (240) | ||
OPTION_IN_PLAN_NAME | VARCHAR2 | (481) | ||
PLAN_NAME | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | VARCHAR2 | (100) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CVG_AMT_CALC_MTHD_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, COVERAGE_NAME
, INCREMENT_VALUE
, MAXIMUM_VALUE
, MINIMUM_VALUE
, NO_MAXIMUM_VALUE
, NO_MINIMUM_VALUE
, ROUNDING_CODE
, ROUNDING_RULE
, VALUE
, VALUE_OVERRIDE_ALLOWED
, VALUE_RULE
, UNIT_OF_MEASURE
, NONMONETARY
, BOUNDARY_PERIOD
, BENEFIT_TYPE
, COVERAGE_MULTIPLE
, RATE_TYPE
, DEFAULT_VALUE
, ENTER_VALUE_AT_ENROLLMENT
, DEFAULT_FLAG
, LOWER_LIMIT_VALUE
, LOWER_LIMIT_VALUE_RULE
, UPPER_LIMIT_VALUE
, UPPER_LIMIT_VALUE_RULE
, COMPENSATION_LEVEL_FACTOR
, OPTION_IN_PLAN_NAME
, PLAN_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.BEN_CVG_AMT_CALC_MTHD_D;
APPS.BEN_CVG_AMT_CALC_MTHD_D is not referenced by any database object
|
|
|