[Home] [Help]
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
Name |
EMPLOYEE_NAME |
EMPLOYEE_NUMBER |
BUSINESS_GROUP_NAME |
MANAGER_NAME |
PLAN_NAME |
OPTION_NAME |
AMOUNT |
UNITS |
PERFORMANCE_RATING |
ASSIGNMENT_CHANGED |
ERROR_MESSAGE |
PERSON_RATE_ID |
BENEFIT_ACTION_ID |