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


VIEW: APPS.BEN_PTIP_D

Object Details
Object Name: BEN_PTIP_D
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_PTIP_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
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PTIP_ID NUMBER (15) Yes Foreign Key to BEN_PTIP_F.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
COORDINATE_CVRG_FOR_ALL_PLANS VARCHAR2 (80)
DEPENDANT_DESIGNATION VARCHAR2 (80)
DPNT_NO_CERTIFICATION_REQD VARCHAR2 (80)
DEPENDANT_DOB_REQUIRED VARCHAR2 (80)
PTIP_STATUS VARCHAR2 (80)
MAXIMUM_COVERAGE_ALLOWED NUMBER

MAXIMUM_NUMBER_OF_PLANS NUMBER (15)
MINIMUM_NUMBER_OF_PLANS NUMBER (15)
NO_MAXIMUM_PLANS VARCHAR2 (80)
ORDER_NUMBER NUMBER (15)
PROVIDES_CREDIT VARCHAR2 (80)
REQD_PERIOD_OF_ENROLLMENT NUMBER (15)
REQUIRED_PERIOD_UOM VARCHAR2 (80)
WAIVABLE VARCHAR2 (80)
DERIVED_FACTOR_DPNT_COVERAGE VARCHAR2 (80)
NO_MINIMUM_PLANS VARCHAR2 (80)
SUBJ_TO_SPOUSE_MAX_INSURANCE VARCHAR2 (80)
SUBJ_TO_DPNT_MAX_INSURANCE VARCHAR2 (80)
SUM_PARTICIPANT_INSURANCE VARCHAR2 (80)
IVR VARCHAR2 (90)
WEB_ADDRESS VARCHAR2 (240)
DRVBL_FCTR_APPLIES_RATES VARCHAR2 (80)
DRVBL_FCTR_PRTN_ELIG VARCHAR2 (80)
PROGRAM_NAME VARCHAR2 (240)
COMBINATION_PTIP VARCHAR2 (240)
COMBINATION_PTIP_OPTION 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).
SHORT_NAME VARCHAR2 (30)
SHORT_CODE VARCHAR2 (30)
LEGISLATION_CODE VARCHAR2 (30)
LEGISLATION_SUBGROUP VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      PTIP_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      COORDINATE_CVRG_FOR_ALL_PLANS
,      DEPENDANT_DESIGNATION
,      DPNT_NO_CERTIFICATION_REQD
,      DEPENDANT_DOB_REQUIRED
,      PTIP_STATUS
,      MAXIMUM_COVERAGE_ALLOWED
,      MAXIMUM_NUMBER_OF_PLANS
,      MINIMUM_NUMBER_OF_PLANS
,      NO_MAXIMUM_PLANS
,      ORDER_NUMBER
,      PROVIDES_CREDIT
,      REQD_PERIOD_OF_ENROLLMENT
,      REQUIRED_PERIOD_UOM
,      WAIVABLE
,      DERIVED_FACTOR_DPNT_COVERAGE
,      NO_MINIMUM_PLANS
,      SUBJ_TO_SPOUSE_MAX_INSURANCE
,      SUBJ_TO_DPNT_MAX_INSURANCE
,      SUM_PARTICIPANT_INSURANCE
,      IVR
,      WEB_ADDRESS
,      DRVBL_FCTR_APPLIES_RATES
,      DRVBL_FCTR_PRTN_ELIG
,      PROGRAM_NAME
,      COMBINATION_PTIP
,      COMBINATION_PTIP_OPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SHORT_NAME
,      SHORT_CODE
,      LEGISLATION_CODE
,      LEGISLATION_SUBGROUP
FROM APPS.BEN_PTIP_D;

Dependencies

[top of page]

APPS.BEN_PTIP_D references the following:

SchemaAPPS
SynonymBEN_ACRS_PTIP_CVG_F
SynonymBEN_CMBN_PTIP_F
SynonymBEN_CMBN_PTIP_OPT_F
SynonymBEN_PGM_F
SynonymBEN_PL_TYP_F
SynonymBEN_PTIP_F
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
APPS.BEN_PTIP_D is referenced by following:

SchemaPUBLIC
SynonymBEN_PTIP_D