APPS.CUG_LAUNCH_WORKFLOW_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

    SELECT CSI.incident_number,CSI.workflow_process_id,CSI.incident_type_id,CST.name,CST.workflow,
    CST.autolaunch_workflow_flag
    FROM cs_incidents_all_b CSI, cs_incident_types_vl CST
    WHERE CSI.incident_id = p_incident_id
    AND CST.incident_type_id = CSI.incident_type_id
    FOR UPDATE OF workflow_process_id NOWAIT;

Line: 95

        SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;

Line: 100

          UPDATE CS_INCIDENTS_ALL_B
          SET workflow_process_id = l_wf_process_id,
          last_updated_by = TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
          last_update_date = sysdate
          WHERE CURRENT OF l_ServeReq_csr;

Line: 106

          UPDATE CS_INCIDENTS_ALL_B
          SET workflow_process_id = l_wf_process_id,
          last_update_date = sysdate
          WHERE CURRENT OF l_ServeReq_csr;