eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BENBV_ACTL_PREM_V

Object Details

Object Name:	BENBV_ACTL_PREM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_ACTL_PREM_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
EFFECTIVE_START_DATE	DATE		Yes
EFFECTIVE_END_DATE	DATE		Yes
NAME	VARCHAR2	(240)	Yes
UOM	VARCHAR2	(30)	Yes
PRTL_MO_DET_MTHD_RL	NUMBER	(15)
WSH_RL_DY_MO_NUM	NUMBER	(9)
VAL	NUMBER	(15)
RNDG_RL	NUMBER	(15)
VAL_CALC_RL	NUMBER	(15)
CR_LKBK_VAL	NUMBER
CR_LKBK_UOM	VARCHAR2	(30)
UPR_LMT_VAL	NUMBER
UPR_LMT_CALC_RL	NUMBER	(15)
LWR_LMT_VAL	NUMBER
LWR_LMT_CALC_RL	NUMBER	(15)
VRBL_RT_ADD_ON_CALC_RL	NUMBER	(15)
COMP_OBJECT	VARCHAR2	(4000)
_DF:APR	CHAR	(27)
ACTY_REF_PERD_CD	VARCHAR2	(30)	Yes
ACTY_REF_PERD_CD_M	VARCHAR2	(4000)
PRTL_MO_DET_MTHD_CD	VARCHAR2	(30)
PRTL_MO_DET_MTHD_CD_M	VARCHAR2	(4000)
RT_TYP_CD	VARCHAR2	(30)
RT_TYP_CD_M	VARCHAR2	(4000)
BNFT_RT_TYP_CD	VARCHAR2	(30)
BNFT_RT_TYP_CD_M	VARCHAR2	(4000)
MLT_CD	VARCHAR2	(30)
MLT_CD_M	VARCHAR2	(4000)
PRDCT_CD	VARCHAR2	(30)
PRDCT_CD_M	VARCHAR2	(4000)
RNDG_CD	VARCHAR2	(30)
RNDG_CD_M	VARCHAR2	(4000)
PREM_ASNMT_CD	VARCHAR2	(30)
PREM_ASNMT_CD_M	VARCHAR2	(4000)
PREM_ASNMT_LVL_CD	VARCHAR2	(30)
PREM_ASNMT_LVL_CD_M	VARCHAR2	(4000)
ACTL_PREM_TYP_CD	VARCHAR2	(30)
ACTL_PREM_TYP_CD_M	VARCHAR2	(4000)
PREM_PYR_CD	VARCHAR2	(30)
PREM_PYR_CD_M	VARCHAR2	(4000)
PRSPTV_R_RTSPTV_CD	VARCHAR2	(30)
PRSPTV_R_RTSPTV_CD_M	VARCHAR2	(4000)
CR_LKBK_CRNT_PY_ONLY_FLAG	VARCHAR2	(30)	Yes
CR_LKBK_CRNT_PY_ONLY_FLAG_M	VARCHAR2	(4000)
ACTL_PREM_ID	NUMBER	(15)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
OIPL_ID	NUMBER	(15)
PL_ID	NUMBER	(15)
COMP_LVL_FCTR_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE

Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      UOM
,      PRTL_MO_DET_MTHD_RL
,      WSH_RL_DY_MO_NUM
,      VAL
,      RNDG_RL
,      VAL_CALC_RL
,      CR_LKBK_VAL
,      CR_LKBK_UOM
,      UPR_LMT_VAL
,      UPR_LMT_CALC_RL
,      LWR_LMT_VAL
,      LWR_LMT_CALC_RL
,      VRBL_RT_ADD_ON_CALC_RL
,      COMP_OBJECT
,      _DF:APR
,      ACTY_REF_PERD_CD
,      ACTY_REF_PERD_CD_M
,      PRTL_MO_DET_MTHD_CD
,      PRTL_MO_DET_MTHD_CD_M
,      RT_TYP_CD
,      RT_TYP_CD_M
,      BNFT_RT_TYP_CD
,      BNFT_RT_TYP_CD_M
,      MLT_CD
,      MLT_CD_M
,      PRDCT_CD
,      PRDCT_CD_M
,      RNDG_CD
,      RNDG_CD_M
,      PREM_ASNMT_CD
,      PREM_ASNMT_CD_M
,      PREM_ASNMT_LVL_CD
,      PREM_ASNMT_LVL_CD_M
,      ACTL_PREM_TYP_CD
,      ACTL_PREM_TYP_CD_M
,      PREM_PYR_CD
,      PREM_PYR_CD_M
,      PRSPTV_R_RTSPTV_CD
,      PRSPTV_R_RTSPTV_CD_M
,      CR_LKBK_CRNT_PY_ONLY_FLAG
,      CR_LKBK_CRNT_PY_ONLY_FLAG_M
,      ACTL_PREM_ID
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ORGANIZATION_ID
,      OIPL_ID
,      PL_ID
,      COMP_LVL_FCTR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_ACTL_PREM_V;

Dependencies

[top of page]

APPS.BENBV_ACTL_PREM_V references the following:

APPS: BEN_ACTL_PREM_F; BEN_BIS_UTILS - show dependent code; HR_BIS - show dependent code

APPS.BENBV_ACTL_PREM_V is not referenced by any database object