FND Design Data [Home] [Help]

View: BEN_CMBN_PLIP_D

Product: BEN - Advanced Benefits
Description:
Implementation/DBA Data: ViewAPPS.BEN_CMBN_PLIP_D
View Text

SELECT CPL.ROWID ROW_ID
, CPL.CMBN_PLIP_ID
, CPL.EFFECTIVE_START_DATE
, CPL.EFFECTIVE_END_DATE
, CPL.NAME
, PGM.NAME
, CPL.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_CMBN_PLIP_F CPL
, FND_USER FUSER
, BEN_PGM_F PGM
WHERE FUSER.USER_ID (+)= CPL .LAST_UPDATED_BY
AND PGM.PGM_ID (+)= CPL .PGM_ID

Columns

Name
ROW_ID
CMBN_PLIP_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
NAME
PGM_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY