View: BEN_CWB_PPAUD_DOWNLOAD_V

Product:	BEN - Advanced Benefits
Description:	View to download the Post Process Audit Log Report using webadi.
Implementation/DBA Data:	APPS.BEN_CWB_PPAUD_DOWNLOAD_V

View Text

SELECT FULL_NAME EMPLOYEE_NAME
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, MANAGER_NAME MANAGER_NAME
, PL_NAME PLAN_NAME
, OPT_NAME OPTION_NAME
, AMOUNT AMOUNT
, UNITS UNITS
, PERFORMANCE_RATING PERFORMANCE_RATING
, ASSIGNMENT_CHANGED_FLAG ASSIGNMENT_CHANGED
, ERROR_OR_WARNING_TEXT ERROR_MESSAGE
, PERSON_RATE_ID PERSON_RATE_ID
, BENEFIT_ACTION_ID
FROM BEN_CWB_RPT_DETAIL
WHERE NVL(PERSON_RATE_ID
, 0) <> -9999 ORDER BY FULL_NAME

Columns