DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on CS_INCIDENT_STATUSES

Line 48: FROM cs_incident_statuses status,

44: inc.resource_type,
45: inc.incident_owner_id,
46: inc.incident_id,
47: inc.object_version_number
48: FROM cs_incident_statuses status,
49: cs_incidents_all_b inc,
50: cs_incident_types cit
51: WHERE inc.incident_number = l_request_number
52: AND inc.incident_status_id = status.incident_status_id

Line 412: FROM cs_incident_statuses status,

408: inc.resource_type,
409: inc.incident_owner_id,
410: inc.incident_id,
411: inc.object_version_number
412: FROM cs_incident_statuses status,
413: cs_incidents_all_b inc,
414: cs_incident_types cit
415: WHERE inc.incident_number = p_Incident_Number
416: AND inc.incident_status_id = status.incident_status_id

Line 656: FROM cs_incident_statuses_vl

652: IF (p_Old_SR_Rec.STATUS_ID <> p_New_SR_Rec.STATUS_ID) THEN
653:
654: SELECT name
655: INTO l_old_request_status
656: FROM cs_incident_statuses_vl
657: WHERE INCIDENT_STATUS_ID = p_Old_SR_Rec.STATUS_ID;
658:
659: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_OLD',
660: p_value => l_old_request_status,