[Home] [Help]
View: 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 |