FND Design Data [Home] [Help]

View: BEN_ACRS_PTIP_CVG_D

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

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

Columns

Name
ROW_ID
ACRS_PTIP_CVG_ID
NAME
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
MX_CVG_ALWD_AMT
MN_CVG_ALWD_AMT
LAST_UPDATE_DATE
LAST_UPDATED_BY