for循环语句插入语句
begin
  for p_uw_condition in (select tr.riskcode
                           from pub_risk tr
                          where tr.validind = '1'
                            and tr.riskcode not in
                                (select t.riskcode
                                   from PUB_Code_Risk t
                                  where 1 = 1
                                    AND (VALIDIND = '1')
                                    AND (COMPANYCODE = '01')
                                    AND (CODETYPE = 'ClaimDocumentType')
                                    AND t.codecode = 'A000'))
 
   loop
    -- 获取预付所有的险种及模板信息
    for c_uw_condition in (select t.*
                             from PUB_Code_Risk t
                            where 1 = 1
                              AND (VALIDIND = '1')
                              AND (COMPANYCODE = '01')
                              AND (CODETYPE = 'ClaimDocumentType')
                              AND t.codecode = 'A000'
                              and t.riskcode = '1401') loop
   
      c_uw_condition.riskcode := p_uw_condition.riskcode ;
     
     &nbs