XXX2

AND EXISTS ( SELECT 1 FROM rims_treaty_prop_risk_plan rp WHERE (rp.treaty_no = p.treaty_no AND rp.id_rims_treaty_prop_section = p.id_rims_treaty_prop_section AND rp.risk_class_code = l.risk_class_code) ) AND NOT EXISTS ( SELECT 1 FROM rims_treaty_prop_risk_plan_t rp WHERE (rp.treaty_no = p.treaty_no AND rp.id_rims_treaty_prop_section = p.id_rims_treaty_prop_section AND rp.risk_class_code = l.risk_class_code) )) UNION SELECT p.id_rims_treaty_prop_section_t AS "idRimsTreatyPropSection", p.section_name AS "sectionName", section_type AS "sectionType", '00riskClassCode', '无风险等级riskClassName' , reinsucde.pkg_rims_treaty_prop.get_operate_flag(p.treaty_no, p.id_rims_treaty_prop_section_t, '00', 1) AS "operateFlag" , reinsucde.pkg_rims_treaty_prop.get_rule_is_same(p.treaty_no, p.id_rims_treaty_prop_section_t, '00') AS "isRuleSame" FROM rims_treaty_prop_section_t p WHERE EXISTS ( SELECT 1 FROM rims_treaty_prop_sect_plan_t t, rims_risk_level l WHERE (t.id_rims_treaty_prop_section_t = p.id_rims_treaty_prop_section_t AND (pkg_rims_common_utils.get_plan_class_code(t.plan_code) NOT IN ('J', 'K', '03', 'SH', '02') OR NOT regexp_like