In this session we are going to see how to fetch Notes from the Oracle Cloud WFC Compensation Worksheet . Note : The "Notes" from Compensation Worksheet is stored as a CLOB . So you need to use html2fo RTF function to convert html data to text . (<? html2fo : NOTE_TXT ?>) . with people_tbl_vw as ( select person_id , person_number from per_all_people_f papf where 1 = 1 and sysdate between papf . effective_start_date and papf . effective_end_date and ( coalesce ( null ,: p_pers_num ) is null or papf . person_id in (: p_pers_num )) ) , cmp_plan_prd_tbl_vw as ( select cpp . plan_id , cpp . period_id from cmp_plan_periods cpp where 1 = 1 and ( coalesce ( null ,: p_plan ) is null or cpp . period_id in (: p_plan )) ) , cmp_cwb_person_info_tbl_vw as ( select ccpi . person_number , cpv . plan_name , cpp . period_name , replace ( rep...