VIEW: APPS.BEN_CWB_PPAUD_DOWNLOAD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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