DBA Data[Home] [Help]

APPS.CS_WORKFLOW_PUB dependencies on WF_ACTIVITIES

Line 106: FROM wf_activities

102: AND status.incident_status_id = inc.incident_status_id;
103:
104: CURSOR l_Wf_ItemType IS -- Bug 6449697
105: SELECT item_type
106: FROM wf_activities
107: WHERE name = l_workflow_proc
108: AND trunc(NVL(begin_date,sysdate)) <= trunc(sysdate)
109: AND trunc(NVL(end_date,sysdate)) >= trunc(sysdate);
110:

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: