update psgm_suffix set creategrpsql = 'select group_id_seq.nextval,
m.display_name||'' ''||d.department_desc||'' ''||:v_gensuff,
''CSGM'',1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,d.department_id,''DEPARTMENT'',null,null,:v_psgmid,
d.department_id,''1'',''1'',0,sysdate,sysdate,sysdate,5772,sysdate,5772,
                   sysdate,0,0,0,5772,''CNAV'',:v_genseq 
               from member m,department d,grouping g
               where m.member_type_code = ''INSTITUTE''
                 and d.institution_id = m.cnav_member_id  
                 and g.parent_group_id(+) = :v_psgmid  
                 and g.entity_id(+)= d.department_id
                 and g.entity_id is null
                 and g.generation_sequence(+) = :v_genseq';