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


VIEW: APPS.BEN_PGM_D

Object Details
Object Name: BEN_PGM_D
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_PGM_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)

PGM_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
NAME VARCHAR2 (240) Yes
DPNT_ADRS_RQD_MEANING VARCHAR2 (80)

PGM_PRVDS_NO_AUTO_ENRT_MEANING VARCHAR2 (80)

DPNT_DOB_RQD_MEANING VARCHAR2 (80)

PGM_PRVDS_NO_DFLT_ENRT_MEANING VARCHAR2 (80)

DPNT_LEGV_ID_RQD_MEANING VARCHAR2 (80)

DPNT_DSGN_LVL_MEANING VARCHAR2 (80)

PGM_STAT_MEANING VARCHAR2 (80)

IVR_IDENT VARCHAR2 (90)

PGM_TYP_MEANING VARCHAR2 (80)

ELIG_APLS_MEANING VARCHAR2 (80)

URL_REF_NAME VARCHAR2 (240)

PGM_DESC VARCHAR2 (2000)

DPNT_DSGN_MEANING VARCHAR2 (80)

MX_DPNT_PCT_PRTT_LF_AMT NUMBER (15)

MX_SPS_PCT_PRTT_LF_AMT NUMBER (15)

ACTY_REF_PERD_MEANING VARCHAR2 (80)

COORD_CVG_FOR_ALL_PLS_FLG VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE


LAST_UPDATED_BY VARCHAR2 (100)

SHORT_NAME VARCHAR2 (30)

DFLT_PGM_FLAG VARCHAR2 (4000)

USE_PROG_POINTS_FLAG VARCHAR2 (4000)

DFLT_STEP_MEANING VARCHAR2 (4000)

DFLT_STEP_RL NUMBER (15)

UPDATE_SALARY_MEANING VARCHAR2 (4000)

USE_MULTI_PAY_RATES_FLAG VARCHAR2 (4000)

DFLT_ELEMENT_TYPE_ID NUMBER (15)

DFLT_INPUT_VALUE_ID NUMBER (15)

USE_SCORES_MEANING VARCHAR2 (4000)

SCORES_CALC_MTHD_MEANING VARCHAR2 (4000)

SCORES_CALC_RL NUMBER (15)

Query Text

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


SELECT ROW_ID
,      PGM_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      DPNT_ADRS_RQD_MEANING
,      PGM_PRVDS_NO_AUTO_ENRT_MEANING
,      DPNT_DOB_RQD_MEANING
,      PGM_PRVDS_NO_DFLT_ENRT_MEANING
,      DPNT_LEGV_ID_RQD_MEANING
,      DPNT_DSGN_LVL_MEANING
,      PGM_STAT_MEANING
,      IVR_IDENT
,      PGM_TYP_MEANING
,      ELIG_APLS_MEANING
,      URL_REF_NAME
,      PGM_DESC
,      DPNT_DSGN_MEANING
,      MX_DPNT_PCT_PRTT_LF_AMT
,      MX_SPS_PCT_PRTT_LF_AMT
,      ACTY_REF_PERD_MEANING
,      COORD_CVG_FOR_ALL_PLS_FLG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SHORT_NAME
,      DFLT_PGM_FLAG
,      USE_PROG_POINTS_FLAG
,      DFLT_STEP_MEANING
,      DFLT_STEP_RL
,      UPDATE_SALARY_MEANING
,      USE_MULTI_PAY_RATES_FLAG
,      DFLT_ELEMENT_TYPE_ID
,      DFLT_INPUT_VALUE_ID
,      USE_SCORES_MEANING
,      SCORES_CALC_MTHD_MEANING
,      SCORES_CALC_RL
FROM APPS.BEN_PGM_D;

Dependencies

[top of page]

APPS.BEN_PGM_D references the following:

SchemaAPPS
SynonymBEN_PGM_F
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOOKUPS
APPS.BEN_PGM_D is referenced by following:

SchemaPUBLIC
SynonymBEN_PGM_D