DBA Data[Home] [Help]

APPS.CSL_CONTRACT_HANDLING_PKG dependencies on CS_INCIDENTS_ALL_B

Line 577: , CS_INCIDENTS_ALL_B cs

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

Line 606: FROM CS_INCIDENTS_ALL_B CS

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: