Skip to content

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

VIEW: BEN.BEN_LER_BNFT_RSTRN_F#

Object Details
Object Name: BEN_LER_BNFT_RSTRN_F#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LER_BNFT_RSTRN_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
NO_MN_CVG_INCR_APLS_FLAG VARCHAR2 (30) Yes
NO_MX_CVG_AMT_APLS_FLAG VARCHAR2 (30) Yes
NO_MX_CVG_INCR_APLS_FLAG VARCHAR2 (30) Yes
LER_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
LBR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
LBR_ATTRIBUTE1 VARCHAR2 (150)
LBR_ATTRIBUTE2 VARCHAR2 (150)
LBR_ATTRIBUTE3 VARCHAR2 (150)
LBR_ATTRIBUTE4 VARCHAR2 (150)
LBR_ATTRIBUTE5 VARCHAR2 (150)
LBR_ATTRIBUTE6 VARCHAR2 (150)
LBR_ATTRIBUTE7 VARCHAR2 (150)
LBR_ATTRIBUTE8 VARCHAR2 (150)
LBR_ATTRIBUTE9 VARCHAR2 (150)
LBR_ATTRIBUTE10 VARCHAR2 (150)
LBR_ATTRIBUTE11 VARCHAR2 (150)
LBR_ATTRIBUTE12 VARCHAR2 (150)
LBR_ATTRIBUTE13 VARCHAR2 (150)
LBR_ATTRIBUTE14 VARCHAR2 (150)
LBR_ATTRIBUTE15 VARCHAR2 (150)
LBR_ATTRIBUTE16 VARCHAR2 (150)
LBR_ATTRIBUTE17 VARCHAR2 (150)
LBR_ATTRIBUTE18 VARCHAR2 (150)
LBR_ATTRIBUTE19 VARCHAR2 (150)
LBR_ATTRIBUTE20 VARCHAR2 (150)
LBR_ATTRIBUTE21 VARCHAR2 (150)
LBR_ATTRIBUTE22 VARCHAR2 (150)
LBR_ATTRIBUTE23 VARCHAR2 (150)
LBR_ATTRIBUTE24 VARCHAR2 (150)
LBR_ATTRIBUTE25 VARCHAR2 (150)
LBR_ATTRIBUTE26 VARCHAR2 (150)
LBR_ATTRIBUTE27 VARCHAR2 (150)
LBR_ATTRIBUTE28 VARCHAR2 (150)
LBR_ATTRIBUTE29 VARCHAR2 (150)
LBR_ATTRIBUTE30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
DFLT_TO_ASN_PNDG_CTFN_CD VARCHAR2 (30)
DFLT_TO_ASN_PNDG_CTFN_RL NUMBER (15)
MX_CVG_INCR_WCF_ALWD_AMT NUMBER

MX_CVG_INCR_ALWD_AMT NUMBER

MX_CVG_ALWD_AMT NUMBER

MX_CVG_MLT_INCR_NUM NUMBER (15)
MX_CVG_MLT_INCR_WCF_NUM NUMBER (15)
MX_CVG_RL NUMBER (15)
MX_CVG_WCFN_AMT NUMBER

MX_CVG_WCFN_MLT_NUM NUMBER (15)
MN_CVG_AMT NUMBER

MN_CVG_RL NUMBER (15)
CVG_INCR_R_DECR_ONLY_CD VARCHAR2 (30)
UNSSPND_ENRT_CD VARCHAR2 (30)
PL_ID NUMBER (15)
PLIP_ID NUMBER (15)
SUSP_IF_CTFN_NOT_PRVD_FLAG VARCHAR2 (30) Yes
CTFN_DETERMINE_CD VARCHAR2 (30)
Query Text

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


SELECT LER_BNFT_RSTRN_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NO_MN_CVG_INCR_APLS_FLAG
,      NO_MX_CVG_AMT_APLS_FLAG
,      NO_MX_CVG_INCR_APLS_FLAG
,      LER_ID
,      BUSINESS_GROUP_ID
,      LBR_ATTRIBUTE_CATEGORY
,      LBR_ATTRIBUTE1
,      LBR_ATTRIBUTE2
,      LBR_ATTRIBUTE3
,      LBR_ATTRIBUTE4
,      LBR_ATTRIBUTE5
,      LBR_ATTRIBUTE6
,      LBR_ATTRIBUTE7
,      LBR_ATTRIBUTE8
,      LBR_ATTRIBUTE9
,      LBR_ATTRIBUTE10
,      LBR_ATTRIBUTE11
,      LBR_ATTRIBUTE12
,      LBR_ATTRIBUTE13
,      LBR_ATTRIBUTE14
,      LBR_ATTRIBUTE15
,      LBR_ATTRIBUTE16
,      LBR_ATTRIBUTE17
,      LBR_ATTRIBUTE18
,      LBR_ATTRIBUTE19
,      LBR_ATTRIBUTE20
,      LBR_ATTRIBUTE21
,      LBR_ATTRIBUTE22
,      LBR_ATTRIBUTE23
,      LBR_ATTRIBUTE24
,      LBR_ATTRIBUTE25
,      LBR_ATTRIBUTE26
,      LBR_ATTRIBUTE27
,      LBR_ATTRIBUTE28
,      LBR_ATTRIBUTE29
,      LBR_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      DFLT_TO_ASN_PNDG_CTFN_CD
,      DFLT_TO_ASN_PNDG_CTFN_RL
,      MX_CVG_INCR_WCF_ALWD_AMT
,      MX_CVG_INCR_ALWD_AMT
,      MX_CVG_ALWD_AMT
,      MX_CVG_MLT_INCR_NUM
,      MX_CVG_MLT_INCR_WCF_NUM
,      MX_CVG_RL
,      MX_CVG_WCFN_AMT
,      MX_CVG_WCFN_MLT_NUM
,      MN_CVG_AMT
,      MN_CVG_RL
,      CVG_INCR_R_DECR_ONLY_CD
,      UNSSPND_ENRT_CD
,      PL_ID
,      PLIP_ID
,      SUSP_IF_CTFN_NOT_PRVD_FLAG
,      CTFN_DETERMINE_CD
FROM BEN.BEN_LER_BNFT_RSTRN_F#;

Dependencies

[top of page]

BEN.BEN_LER_BNFT_RSTRN_F# references the following:

SchemaBEN
TableBEN_LER_BNFT_RSTRN_F
BEN.BEN_LER_BNFT_RSTRN_F# is referenced by following:

SchemaAPPS
SynonymBEN_LER_BNFT_RSTRN_F
TriggerBEN_LER_BNFT_RSTRN_F_WHO