APPS.CS_WF_EVENT_PKG dependencies on CS_INCIDENT_STATUSES

Line 54: FROM cs_incident_statuses status,

50: inc.resource_type,
51: inc.incident_owner_id,
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

Line 720: FROM cs_incident_statuses status,

716: inc.resource_type,
717: inc.incident_owner_id,
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

Line 964: FROM cs_incident_statuses_vl

960: IF (p_Old_SR_Rec.STATUS_ID <> p_New_SR_Rec.STATUS_ID) THEN
961:
962: SELECT name
963: INTO l_old_request_status
964: FROM cs_incident_statuses_vl
965: WHERE INCIDENT_STATUS_ID = p_Old_SR_Rec.STATUS_ID;
966:
967: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_OLD',
968: p_value => l_old_request_status,

Line 978: FROM cs_incident_statuses_vl

974: -- This is to avoid missing/wrong notifications being sent when status change happens rapidly
975:
976: SELECT name
977: INTO l_new_request_status
978: FROM cs_incident_statuses_vl
979: WHERE INCIDENT_STATUS_ID = p_New_SR_Rec.STATUS_ID;
980:
981:
982: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_NEW',