View: BEN_APLCN_TO_BNFT_POOL_D

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

View Text

SELECT ABP.ROWID ROW_ID
, ABP.APLCN_TO_BNFT_POOL_ID
, ABP.EFFECTIVE_START_DATE
, ABP.EFFECTIVE_END_DATE
, ACTY_BASE_RT.NAME
, BNFT_PRVDR_POOL.NAME
, ABP.LAST_UPDATE_DATE
, ABP.LAST_UPDATED_BY
FROM BEN_APLCN_TO_BNFT_POOL_F ABP
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, BEN_BNFT_PRVDR_POOL_F BNFT_PRVDR_POOL
WHERE FUSER.USER_ID (+)= ABP .LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= ABP .ACTY_BASE_RT_ID
AND BNFT_PRVDR_POOL.BNFT_PRVDR_POOL_ID (+)= ABP .BNFT_PRVDR_POOL_ID

Columns