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


VIEW: APPS.BEN_PLIP_D

Object Details
Object Name: BEN_PLIP_D
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_PLIP_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
PLIP_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
PROGRAM_NAME VARCHAR2 (240)

PLAN_NAME VARCHAR2 (240)

DEFAULT_MEANING VARCHAR2 (80)

PLAN_IN_PROGRAM_STATUS VARCHAR2 (80)

DEFAULT_ENROLLMENT VARCHAR2 (80)

DEFAULT_ENROLLMENT_RULE VARCHAR2 (80)

ALLOWS_UNRESTRICTED_ENRT VARCHAR2 (80)

ENROLLMENT_CVG_START_DATE VARCHAR2 (80)

ENROLLMENT_CVG_START_DATE_RULE VARCHAR2 (80)

ENROLLMENT_CVG_END_DATE VARCHAR2 (80)

ENROLLMENT_CVG_END_DATE_RULE VARCHAR2 (80)

RATE_START_DATE VARCHAR2 (80)

RATE_START_DATE_RULE VARCHAR2 (80)

RATE_END_DATE VARCHAR2 (80)

RATE_END_DATE_RULE VARCHAR2 (80)

AUTO_ENROLLMENT_RULE VARCHAR2 (80)

ENROLLMENT VARCHAR2 (80)

ENROLLMENT_METHOD VARCHAR2 (80)

ENROLLMENT_RULE VARCHAR2 (80)

DRVBL_FACTOR_APPLIES_RATES VARCHAR2 (80)

DRVBL_FACTOR_PRTN_ELIG VARCHAR2 (80)

ELIGIBILITY_APPLIES VARCHAR2 (80)

PRTN_ELIGIBLE_OVERRIDE_ALLOWED VARCHAR2 (80)

TRACK_INELIGIBLE_PERSON VARCHAR2 (80)

POST_ELECTION_EDIT_RULE VARCHAR2 (80)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY VARCHAR2 (100)

VERIFY_FAMILY_MEMBER VARCHAR2 (80)

VERIFY_FAMILY_MEMBER_RULE VARCHAR2 (80)

PERSONS_COVERED VARCHAR2 (80)

SHORT_NAME VARCHAR2 (30)

SHORT_CODE VARCHAR2 (30)

Query Text

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


SELECT PLIP_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PROGRAM_NAME
,      PLAN_NAME
,      DEFAULT_MEANING
,      PLAN_IN_PROGRAM_STATUS
,      DEFAULT_ENROLLMENT
,      DEFAULT_ENROLLMENT_RULE
,      ALLOWS_UNRESTRICTED_ENRT
,      ENROLLMENT_CVG_START_DATE
,      ENROLLMENT_CVG_START_DATE_RULE
,      ENROLLMENT_CVG_END_DATE
,      ENROLLMENT_CVG_END_DATE_RULE
,      RATE_START_DATE
,      RATE_START_DATE_RULE
,      RATE_END_DATE
,      RATE_END_DATE_RULE
,      AUTO_ENROLLMENT_RULE
,      ENROLLMENT
,      ENROLLMENT_METHOD
,      ENROLLMENT_RULE
,      DRVBL_FACTOR_APPLIES_RATES
,      DRVBL_FACTOR_PRTN_ELIG
,      ELIGIBILITY_APPLIES
,      PRTN_ELIGIBLE_OVERRIDE_ALLOWED
,      TRACK_INELIGIBLE_PERSON
,      POST_ELECTION_EDIT_RULE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VERIFY_FAMILY_MEMBER
,      VERIFY_FAMILY_MEMBER_RULE
,      PERSONS_COVERED
,      SHORT_NAME
,      SHORT_CODE
FROM APPS.BEN_PLIP_D;

Dependencies

[top of page]

APPS.BEN_PLIP_D references the following:

SchemaAPPS
SynonymBEN_PGM_F
SynonymBEN_PLIP_F
SynonymBEN_PL_F
SynonymFF_FORMULAS_F
SynonymFND_USER
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS

APPS.BEN_PLIP_D is not referenced by any database object