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_PL_FRFS_VAL_D

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

View Text

SELECT FRP.ROWID ROW_ID
, FRP.PL_FRFS_VAL_ID
, FRP.EFFECTIVE_START_DATE
, FRP.EFFECTIVE_END_DATE
, FRP.PL_ID
, FRP.START_DATE
, FRP.END_DATE
, FRP.TTL_CNTR_VAL
, FRP.TTL_DISTR_VAL
, FRP.TTL_FRFD_VAL
, PLN.NAME
, FRP.LAST_UPDATE_DATE
, FRP.LAST_UPDATED_BY
FROM BEN_PL_FRFS_VAL_F FRP
, FND_USER FUSER
, BEN_PL_F PLN
WHERE FUSER.USER_ID (+)= FRP .LAST_UPDATED_BY
AND FRP.PL_ID = PLN.PL_ID
AND FRP.EFFECTIVE_START_DATE BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE

Columns

Name
ROW_ID
PL_FRFS_VAL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
PL_ID
START_DATE
END_DATE
TTL_CNTR_VAL
TTL_DISTR_VAL
TTL_FRFD_VAL
PLAN_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY