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


VIEW: APPS.BEN_CWB_SUMM_DIR_REP_V

Object Details
Object Name: BEN_CWB_SUMM_DIR_REP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_CWB_SUMM_DIR_REP_V
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
GRP_LER_ID NUMBER (15) Yes Group Per In Ler Id
GRP_PL_ID NUMBER (15) Yes Group Plan Id
GRP_OIPL_ID NUMBER (15)
Group Oipl Id
NAME VARCHAR2 (480)
Manager Name
ELIG_EMP NUMBER

Eligible Employees
EMP_RECV NUMBER

Employees Receiving
PCT_EMP_RECV VARCHAR2 (40)
Percent of Employees Receiving
ELIG_SAL NUMBER

Eligible Salary
BUDGET NUMBER

Budget
PCT_OF_BDGT VARCHAR2 (40)
Percent of Budget
TOT_ALCT NUMBER

Total Allocated
PL_UOM VARCHAR2 (80)
Units Units
PCT_OF_SAL VARCHAR2 (40)
Percent of Eligible Salary
AVAILABLE NUMBER

Available Amount
AVG_ALCT VARCHAR2 (40)
Average Allocation
Query Text

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


SELECT GRP_LER_ID
,      GRP_PL_ID
,      GRP_OIPL_ID
,      NAME
,      ELIG_EMP
,      EMP_RECV
,      PCT_EMP_RECV
,      ELIG_SAL
,      BUDGET
,      PCT_OF_BDGT
,      TOT_ALCT
,      PL_UOM
,      PCT_OF_SAL
,      AVAILABLE
,      AVG_ALCT
FROM APPS.BEN_CWB_SUMM_DIR_REP_V;

Dependencies

[top of page]

APPS.BEN_CWB_SUMM_DIR_REP_V references the following:

SchemaAPPS
SynonymBEN_CWB_GROUP_HRCHY
SynonymBEN_CWB_PERSON_GROUPS
SynonymBEN_CWB_PERSON_INFO
SynonymBEN_CWB_PL_DSGN
SynonymBEN_CWB_SUMMARY
PL/SQL PackageBEN_CWB_UTILS - show dependent code
SynonymFND_CURRENCIES
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
APPS.BEN_CWB_SUMM_DIR_REP_V is referenced by following:

SchemaPUBLIC
SynonymBEN_CWB_SUMM_DIR_REP_V