APPS.CS_WF_EVENT_PKG dependencies on WF_ITEMS

Line 65: FROM wf_items

61: l_sel_workflow_rec sel_workflow_csr%ROWTYPE;
62:
63: CURSOR l_servereq_csr IS
64: SELECT end_date
65: FROM wf_items
66: WHERE item_type = 'SERVEREQ'
67: AND item_key like l_request_number||'-%'
68: AND item_key NOT like l_request_number||'%EVT'
69: AND end_date IS NULL;

Line 320: FROM wf_items

316: l_sel_workflow_rec sel_workflow_csr%ROWTYPE;
317:
318: CURSOR l_servereq_csr IS
319: SELECT end_date
320: FROM wf_items
321: WHERE item_type = 'SERVEREQ'
322: AND item_key like l_request_number||'-%'
323: AND item_key NOT like l_request_number||'%EVT'
324: AND end_date IS NULL;

Line 758: FROM wf_items

754: **/
755:
756: CURSOR l_servereq_csr IS
757: SELECT end_date,item_key
758: FROM wf_items
759: WHERE item_type = 'SERVEREQ'
760: AND item_key like p_Incident_Number||'-%'
761: AND item_key NOT like p_Incident_Number||'%EVT'
762: AND end_date IS NULL;