VIEW: APPS.BEN_ACRS_PTIP_CVG_D

Source

View Text - Preformatted

SELECT apc.ROWID ROW_ID, apc.ACRS_PTIP_CVG_ID ,apc.NAME ,apc.EFFECTIVE_START_DATE ,apc.EFFECTIVE_END_DATE ,apc.MX_CVG_ALWD_AMT ,apc.MN_CVG_ALWD_AMT ,apc.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_ACRS_PTIP_CVG_F apc ,fnd_user fuser WHERE fuser.user_id (+)= apc.last_updated_by

View Text - HTML Formatted

SELECT APC.ROWID ROW_ID
, APC.ACRS_PTIP_CVG_ID
, APC.NAME
, APC.EFFECTIVE_START_DATE
, APC.EFFECTIVE_END_DATE
, APC.MX_CVG_ALWD_AMT
, APC.MN_CVG_ALWD_AMT
, APC.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ACRS_PTIP_CVG_F APC
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= APC.LAST_UPDATED_BY