VIEW: APPS.BEN_CMBN_PLIP_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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