VIEW: APPS.BEN_CMBN_PTIP_D

Source

View Text - Preformatted

SELECT CBP.ROWID ROW_ID , CBP.CMBN_PTIP_ID , CBP.EFFECTIVE_START_DATE , CBP.EFFECTIVE_END_DATE , CBP.NAME , PGM.NAME , CBP.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY from BEN_CMBN_PTIP_F cbp, fnd_user fuser ,BEN_PGM_F PGM WHERE fuser.user_id (+)= cbp .last_updated_by and PGM.PGM_ID (+)= cbp .PGM_ID

View Text - HTML Formatted

SELECT CBP.ROWID ROW_ID
, CBP.CMBN_PTIP_ID
, CBP.EFFECTIVE_START_DATE
, CBP.EFFECTIVE_END_DATE
, CBP.NAME
, PGM.NAME
, CBP.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_CMBN_PTIP_F CBP
, FND_USER FUSER
, BEN_PGM_F PGM
WHERE FUSER.USER_ID (+)= CBP .LAST_UPDATED_BY
AND PGM.PGM_ID (+)= CBP .PGM_ID