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.
[Home] [Help]
View: BENBV_CBR_PER_IN_LER_V
Product: BEN - Advanced Benefits
Description: This view contains persons who have experienced a life event which may make the person eligible to participate in extended benefits as legislated under COBRA.
Implementation/DBA Data:
APPS.BENBV_CBR_PER_IN_LER_V
View Text
SELECT CRP.CNT_NUM , CRP.PRVS_ELIG_PERD_END_DT , /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CBR_PER_IN_LER_F:CRP' , CRP.INIT_EVT_FLAG , HR_BIS.BIS_DECODE_LOOKUP('YES_NO' , CRP.INIT_EVT_FLAG) , /* ID COLUMNS */ CRP.CBR_PER_IN_LER_ID , CRP.PER_IN_LER_ID , CRP.CBR_QUALD_BNF_ID , CRP.BUSINESS_GROUP_ID , /* WHO COLUMNS */ CRP.LAST_UPDATE_DATE , CRP.LAST_UPDATED_BY , CRP.CREATED_BY , CRP.CREATION_DATE FROM BEN_CBR_PER_IN_LER CRP WHERE CRP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , CRP.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name
CNT_NUM
PRVS_ELIG_PERD_END_DT
"_DF:CRP"
INIT_EVT_FLAG
INIT_EVT_FLAG_M
CBR_PER_IN_LER_ID
PER_IN_LER_ID
CBR_QUALD_BNF_ID
BUSINESS_GROUP_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE