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


VIEW: APPS.BEN_BENEFIT_CONTRIBUTIONS_D

Object Details
Object Name: BEN_BENEFIT_CONTRIBUTIONS_D
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.BEN_BENEFIT_CONTRIBUTIONS_D
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BENEFIT_CONTRIBUTION_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
FORMULA_NAME VARCHAR2 (80)
ELEMENT_NAME VARCHAR2 (80)
COVERAGE_TYPE VARCHAR2 (80)
EMPLOYEE_CONTRIBUTION VARCHAR2 (60) Yes
EMPLOYER_CONTRIBUTION VARCHAR2 (60) Yes
MAXIMUM_EMPLOYEE_CONTRIBUTION VARCHAR2 (60)
MAXIMUM_EMPLOYER_CONTRIBUTION VARCHAR2 (60)
MINIMUM_EMPLOYEE_CONTRIBUTION VARCHAR2 (60)
MINIMUM__EMPLOYER_CONTRIBUTION VARCHAR2 (60)
LAST_UPDATE_DATE DATE

LAST_UPDATE_BY VARCHAR2 (100)
Query Text

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


SELECT BENEFIT_CONTRIBUTION_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      FORMULA_NAME
,      ELEMENT_NAME
,      COVERAGE_TYPE
,      EMPLOYEE_CONTRIBUTION
,      EMPLOYER_CONTRIBUTION
,      MAXIMUM_EMPLOYEE_CONTRIBUTION
,      MAXIMUM_EMPLOYER_CONTRIBUTION
,      MINIMUM_EMPLOYEE_CONTRIBUTION
,      MINIMUM__EMPLOYER_CONTRIBUTION
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
FROM APPS.BEN_BENEFIT_CONTRIBUTIONS_D;

Dependencies

[top of page]

APPS.BEN_BENEFIT_CONTRIBUTIONS_D references the following:

SchemaAPPS
SynonymBEN_BENEFIT_CONTRIBUTIONS_F
SynonymFF_FORMULAS_F
SynonymFND_USER
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
SynonymPAY_ELEMENT_TYPES_F

APPS.BEN_BENEFIT_CONTRIBUTIONS_D is not referenced by any database object