APPS.CS_WORKFLOW_PUB dependencies on CS_INCIDENT_TYPES

Line 98: cs_incident_types type,

94: inc.object_version_number,
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;

Line 241: -- FROM cs_incident_types type, cs_incidents_all_vl inc

237:
238: -- Get the workflow process name for this request from the request type
239: -- SELECT type.workflow, type.web_workflow, inc.sr_creation_channel
240: -- INTO l_workflow_proc, l_web_workflow, l_web_entry_flag
241: -- FROM cs_incident_types type, cs_incidents_all_vl inc
242: -- WHERE inc.incident_number = p_request_number
243: -- AND inc.incident_type_id = type.incident_type_id;
244:
245: -- Get the workflow process name for this request from the request type

Line 251: FROM cs_incident_types type, cs_incidents_all_vl inc

247: /**** Combining this with the l_ServeReq_csr cursor above. ***/
248: /**** rmanabat. 032403 .
249: SELECT type.workflow
250: INTO l_workflow_proc
251: FROM cs_incident_types type, cs_incidents_all_vl inc
252: WHERE inc.incident_number = p_request_number
253: AND inc.incident_type_id = type.incident_type_id;
254: ****/
255:

Line 733: from cs_incidents_all_b inc, cs_incident_types types, wf_activities wf

729: l_itemtype VARCHAR2(10); --Bug 6449697
730:
731: CURSOR l_itemtype_csr IS --Bug 6449697
732: Select item_type
733: from cs_incidents_all_b inc, cs_incident_types types, wf_activities wf
734: where inc.incident_number= p_request_number
735: and types.incident_type_id=inc.incident_type_id
736: and wf.name=types.workflow;
737:

Line 1514: FROM cs_incident_actions action, cs_incident_types type

1510: END IF;
1511:
1512: -- Get the workflow process name for this request from the request type
1513: SELECT type.workflow INTO l_workflow_proc
1514: FROM cs_incident_actions action, cs_incident_types type
1515: WHERE action.incident_id = p_request_id
1516: AND action.action_num = p_action_number
1517: AND action.action_type_id = type.incident_type_id;
1518: