573: from okc_k_headers_b h
574: , okc_k_lines_b l
575: , Okx_System_Items_V s
576: , Okc_K_Items IT
577: , CS_INCIDENTS_ALL_B cs
578: where cs.INCIDENT_ID = b_incident_id
579: and cs.CONTRACT_SERVICE_ID = l.id
580: and h.id = l.dnz_chr_id
581: and l.id = it.CLE_ID
602:
603: --Added by UTEKUMAL on 04-Mar-2004 to fix Bug #3478401
604: CURSOR c_csl_contract_service_id (b_incident_id NUMBER) IS
605: SELECT CONTRACT_SERVICE_ID
606: FROM CS_INCIDENTS_ALL_B CS
607: WHERE CS.incident_id = b_incident_id;
608:
609: BEGIN
610: