APPS.CS_SR_WF_DUP_CHK_PVT dependencies on CS_INCIDENTS_ALL_VL

Line 969: FROM cs_incidents_all_vl inc ,jtf_rs_resource_extns emp

965: l_API_ERROR EXCEPTION;
966:
967: CURSOR l_ServiceRequest_csr IS
968: SELECT emp.source_id incident_owner_id
969: FROM cs_incidents_all_vl inc ,jtf_rs_resource_extns emp
970: WHERE inc.INCIDENT_OWNER_ID = emp.resource_id AND
971: incident_id = l_incident_id;
972:
973: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;