232: g_opt3_person_rates_rec ben_cwb_person_rates%RowType;
233: g_opt4_person_rates_rec ben_cwb_person_rates%RowType;
234:
235: -- Added to support worksheet manager name
236: g_ws_mgr_full_name ben_cwb_person_info.full_name%TYPE;
237: g_ws_mgr_brief_name ben_cwb_person_info.brief_name%TYPE;
238: g_ws_mgr_custom_name ben_cwb_person_info.custom_name%TYPE;
239: --
240:
233: g_opt4_person_rates_rec ben_cwb_person_rates%RowType;
234:
235: -- Added to support worksheet manager name
236: g_ws_mgr_full_name ben_cwb_person_info.full_name%TYPE;
237: g_ws_mgr_brief_name ben_cwb_person_info.brief_name%TYPE;
238: g_ws_mgr_custom_name ben_cwb_person_info.custom_name%TYPE;
239: --
240:
241: CURSOR g_cursor_asgn_txn (c_assignment_id number, c_asg_updt_eff_date varchar2) is
234:
235: -- Added to support worksheet manager name
236: g_ws_mgr_full_name ben_cwb_person_info.full_name%TYPE;
237: g_ws_mgr_brief_name ben_cwb_person_info.brief_name%TYPE;
238: g_ws_mgr_custom_name ben_cwb_person_info.custom_name%TYPE;
239: --
240:
241: CURSOR g_cursor_asgn_txn (c_assignment_id number, c_asg_updt_eff_date varchar2) is
242: select transaction_id assignment_id,