DBA Data[Home] [Help]

APPS.CS_WORKFLOW_PUB dependencies on CS_INCIDENT_STATUSES

Line 99: cs_incident_statuses status

95: type.workflow,
96: status.close_flag
97: FROM cs_incidents_all_b inc,
98: cs_incident_types type,
99: cs_incident_statuses status
100: WHERE inc.incident_number = p_request_number
101: AND type.incident_type_id = inc.incident_type_id
102: AND status.incident_status_id = inc.incident_status_id;
103:

Line 270: FROM cs_incident_statuses status, cs_incidents_all_vl inc

266:
267: /**** Combining this with the l_ServeReq_csr cursor above. ***/
268: /**** rmanabat. 032403 .
269: SELECT status.close_flag INTO l_close_flag
270: FROM cs_incident_statuses status, cs_incidents_all_vl inc
271: WHERE inc.incident_number = p_request_number
272: AND inc.incident_status_id = status.incident_status_id;
273: ****/
274: