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: BEN_BACK_OUT_FLX_POOL_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_BACK_OUT_FLX_POOL_V

View Text

SELECT EPE.ELIG_PER_ELCTBL_CHC_ID
, EPE.PGM_ID
, EPE.CMBN_PLIP_ID
, EPE.CMBN_PTIP_ID
, EPE.CMBN_PTIP_OPT_ID
, EPE.PL_ID
, EPE.PL_TYP_ID
, EPE.PTIP_ID
, EPE.PLIP_ID
, EPE.OIPL_ID
, EPE.BNFT_PRVDR_POOL_ID
, EPE.PER_IN_LER_ID
, EPE.BUSINESS_GROUP_ID
FROM BEN_ELIG_PER_ELCTBL_CHC EPE
WHERE EPE.BNFT_PRVDR_POOL_ID IS NOT NULL

Columns

Name
ELIG_PER_ELCTBL_CHC_ID
PGM_ID
CMBN_PLIP_ID
CMBN_PTIP_ID
CMBN_PTIP_OPT_ID
PL_ID
PL_TYP_ID
PTIP_ID
PLIP_ID
OIPL_ID
BNFT_PRVDR_POOL_ID
PER_IN_LER_ID
BUSINESS_GROUP_ID