222: , ci_all_b.contract_service_id contract_service_id
223: , cit.business_process_id business_process_id
224: , ci_all_b.contract_number contract_number
225: FROM cs_incidents_all_b ci_all_b
226: , cs_incident_types cit
227: WHERE ci_all_b.incident_type_id = cit.incident_type_id
228: AND ci_all_b.incident_id = b_incident_id;
229:
230: -- cursor is modified