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

VIEW: APPS.BENBV_CWB_PERSON_GROUPS_V

Object Details
Object Name: BENBV_CWB_PERSON_GROUPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_CWB_PERSON_GROUPS_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
LF_EVT_OCRD_DT DATE
Yes Life Event Occured Date.
DUE_DT DATE

Due Date .
APPROVAL_DATE DATE

Approval Date .
APPROVAL_COMMENTS VARCHAR2 (2000)
Approval Comments .
SUBMIT_DATE DATE

Submit Date .
SUBMIT_COMMENTS VARCHAR2 (2000)
Submit Comments .
DIST_BDGT_VAL NUMBER

Distribution Budget Value .
WS_BDGT_VAL NUMBER

Worksheet Budget Value .
RSRV_VAL NUMBER

Reserve Budget Value .
DIST_BDGT_MN_VAL NUMBER

Distribution Budget Min Value .
DIST_BDGT_MX_VAL NUMBER

Distribution Budget Max Value .
DIST_BDGT_INCR_VAL NUMBER

Distribution Budget Increment Value .
WS_BDGT_MN_VAL NUMBER

Worksheet Budget Min Value .
WS_BDGT_MX_VAL NUMBER

Worksheet Budget Max Value .
WS_BDGT_INCR_VAL NUMBER

Worksheet Budget Incr Value .
RSRV_MN_VAL NUMBER

Reserve Budget Min Value .
RSRV_MX_VAL NUMBER

Reserve Budget Max Value .
RSRV_INCR_VAL NUMBER

Reserve Budget Incr Value .
DIST_BDGT_ISS_VAL NUMBER

Distribution Budget Issued Value .
WS_BDGT_ISS_VAL NUMBER

Worksheet Budget Issued Value .
DIST_BDGT_ISS_DATE DATE

Distribution Budget Issued Date .
WS_BDGT_ISS_DATE DATE

Worksheet Budget Issued Date .
WS_BDGT_VAL_LAST_UPD_DATE DATE

Worksheet Budget Update Date .
DIST_BDGT_VAL_LAST_UPD_DATE DATE

Distribution Budget Update Date .
RSRV_VAL_LAST_UPD_DATE DATE

Reserve Budget Update Date .
WS_BDGT_VAL_LAST_UPD_BY NUMBER (15)
Worksheet Budget Updated by Person .
DIST_BDGT_VAL_LAST_UPD_BY NUMBER (15)
Distribution Budget Updated by Person .
RSRV_VAL_LAST_UPD_BY NUMBER (15)
Reserve Budget Updated by Person .
GROUP_PLAN VARCHAR2 (4000)
Group Plan.
GROUP_OPTION_IN_PLAN VARCHAR2 (4000)
Group Option in Plan.
BDGT_POP_CD VARCHAR2 (30)
Budget Population Code . (Lookup code based on lookup type BEN_POP)
BDGT_POP_CD_M VARCHAR2 (4000)
Budget Population Code . (Lookup meaning based on lookup type BEN_POP)
ACCESS_CD VARCHAR2 (30)
Access Code . (Lookup code based on lookup type BEN_CWB_TASK_ACCESS)
ACCESS_CD_M VARCHAR2 (4000)
Access Code . (Lookup meaning based on lookup type BEN_CWB_TASK_ACCESS)
APPROVAL_CD VARCHAR2 (30)
Approval Code . (Lookup code based on lookup type BEN_APPR_STAT)
APPROVAL_CD_M VARCHAR2 (4000)
Approval Code . (Lookup meaning based on lookup type BEN_APPR_STAT)
SUBMIT_CD VARCHAR2 (30)
Submit Code . (Lookup code based on lookup type BEN_SUBMIT_STAT)
SUBMIT_CD_M VARCHAR2 (4000)
Submit Code . (Lookup meaning based on lookup type BEN_SUBMIT_STAT)
GROUP_PER_IN_LER_ID NUMBER (15) Yes Group Per In Ler Id.
GROUP_PL_ID NUMBER (15) Yes Group Plan .
GROUP_OIPL_ID NUMBER (15) Yes Group Option.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT LF_EVT_OCRD_DT
,      DUE_DT
,      APPROVAL_DATE
,      APPROVAL_COMMENTS
,      SUBMIT_DATE
,      SUBMIT_COMMENTS
,      DIST_BDGT_VAL
,      WS_BDGT_VAL
,      RSRV_VAL
,      DIST_BDGT_MN_VAL
,      DIST_BDGT_MX_VAL
,      DIST_BDGT_INCR_VAL
,      WS_BDGT_MN_VAL
,      WS_BDGT_MX_VAL
,      WS_BDGT_INCR_VAL
,      RSRV_MN_VAL
,      RSRV_MX_VAL
,      RSRV_INCR_VAL
,      DIST_BDGT_ISS_VAL
,      WS_BDGT_ISS_VAL
,      DIST_BDGT_ISS_DATE
,      WS_BDGT_ISS_DATE
,      WS_BDGT_VAL_LAST_UPD_DATE
,      DIST_BDGT_VAL_LAST_UPD_DATE
,      RSRV_VAL_LAST_UPD_DATE
,      WS_BDGT_VAL_LAST_UPD_BY
,      DIST_BDGT_VAL_LAST_UPD_BY
,      RSRV_VAL_LAST_UPD_BY
,      GROUP_PLAN
,      GROUP_OPTION_IN_PLAN
,      BDGT_POP_CD
,      BDGT_POP_CD_M
,      ACCESS_CD
,      ACCESS_CD_M
,      APPROVAL_CD
,      APPROVAL_CD_M
,      SUBMIT_CD
,      SUBMIT_CD_M
,      GROUP_PER_IN_LER_ID
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_CWB_PERSON_GROUPS_V;

Dependencies

[top of page]

APPS.BENBV_CWB_PERSON_GROUPS_V references the following:

SchemaAPPS
PL/SQL PackageBEN_BIS_UTILS - show dependent code
SynonymBEN_CWB_PERSON_GROUPS
PL/SQL PackageHR_BIS - show dependent code
APPS.BENBV_CWB_PERSON_GROUPS_V is referenced by following:

SchemaPUBLIC
SynonymBENBV_CWB_PERSON_GROUPS_V