[Home] [Help]
APPS.CUG_LAUNCH_WORKFLOW_PVT dependencies on CS_INCIDENT_TYPES_VL
Line 47: FROM cs_incidents_all_b CSI, cs_incident_types_vl CST
43:
44: CURSOR l_servereq_csr IS
45: SELECT CSI.incident_number,CSI.workflow_process_id,CSI.incident_type_id,CST.name,CST.workflow,
46: CST.autolaunch_workflow_flag
47: FROM cs_incidents_all_b CSI, cs_incident_types_vl CST
48: WHERE CSI.incident_id = p_incident_id
49: AND CST.incident_type_id = CSI.incident_type_id
50: FOR UPDATE OF workflow_process_id NOWAIT;
51: