APPS.CS_WF_EVENT_PKG dependencies on WF_ITEMS

Line 59: FROM wf_items

55: l_sel_workflow_rec sel_workflow_csr%ROWTYPE;
56:
57: CURSOR l_servereq_csr IS
58: SELECT end_date
59: FROM wf_items
60: WHERE item_type = 'SERVEREQ'
61: AND item_key like l_request_number||'-%'
62: AND item_key NOT like l_request_number||'%EVT'
63: AND end_date IS NULL;

Line 450: FROM wf_items

446: **/
447:
448: CURSOR l_servereq_csr IS
449: SELECT end_date,item_key
450: FROM wf_items
451: WHERE item_type = 'SERVEREQ'
452: AND item_key like p_Incident_Number||'-%'
453: AND item_key NOT like p_Incident_Number||'%EVT'
454: AND end_date IS NULL;