DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on CS_INCIDENT_TYPES

Line 56: cs_incident_types cit

52: inc.incident_id,
53: inc.object_version_number
54: FROM cs_incident_statuses status,
55: cs_incidents_all_b inc,
56: cs_incident_types cit
57: WHERE inc.incident_number = l_request_number
58: AND inc.incident_status_id = status.incident_status_id
59: and cit.incident_type_id = inc.incident_type_id;
60:

Line 310: cs_incident_types_b t2

306:
307: CURSOR sel_workflow_csr IS
308: SELECT t1.workflow
309: FROM cs_sr_status_transitions t1,
310: cs_incident_types_b t2
311: WHERE t2.status_group_id=t1.status_group_id
312: AND t1.from_incident_status_id=l_from_status_id
313: AND t1.to_incident_status_id=l_to_status_id
314: AND t2.incident_type_id=l_type_id;

Line 722: cs_incident_types cit

718: inc.incident_id,
719: inc.object_version_number
720: FROM cs_incident_statuses status,
721: cs_incidents_all_b inc,
722: cs_incident_types cit
723: WHERE inc.incident_number = p_Incident_Number
724: AND inc.incident_status_id = status.incident_status_id
725: and cit.incident_type_id = inc.incident_type_id;
726: