VIEW: APPS.BENBV_ENRT_PREM_V

Source

View Text - Preformatted

SELECT EPR.PROGRAM_UPDATE_DATE, EPR.VAL, EPR.UOM, /* descriptive flexfield */ '_DF:BEN:BEN_ENRT_PREM_F:EPR', /* id columns */ EPR.ENRT_PREM_ID, EPR.ACTL_PREM_ID, EPR.BUSINESS_GROUP_ID, EPR.REQUEST_ID, EPR.PROGRAM_APPLICATION_ID, EPR.PROGRAM_ID, EPR.ELIG_PER_ELCTBL_CHC_ID, EPR.ENRT_BNFT_ID, /* who columns */ EPR.LAST_UPDATE_DATE, EPR.LAST_UPDATED_BY, EPR.CREATED_BY, EPR.CREATION_DATE FROM BEN_ENRT_PREM EPR WHERE EPR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, EPR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT EPR.PROGRAM_UPDATE_DATE
, EPR.VAL
, EPR.UOM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ENRT_PREM_F:EPR'
, /* ID COLUMNS */ EPR.ENRT_PREM_ID
, EPR.ACTL_PREM_ID
, EPR.BUSINESS_GROUP_ID
, EPR.REQUEST_ID
, EPR.PROGRAM_APPLICATION_ID
, EPR.PROGRAM_ID
, EPR.ELIG_PER_ELCTBL_CHC_ID
, EPR.ENRT_BNFT_ID
, /* WHO COLUMNS */ EPR.LAST_UPDATE_DATE
, EPR.LAST_UPDATED_BY
, EPR.CREATED_BY
, EPR.CREATION_DATE
FROM BEN_ENRT_PREM EPR
WHERE EPR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EPR.BUSINESS_GROUP_ID) WITH READ ONLY