VIEW: APPS.BEN_APLCN_TO_BNFT_POOL_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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