VIEW: APPS.BENBV_CBR_PER_IN_LER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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