DBA Data[Home] [Help]

APPS.CS_SR_WORKITEM_PVT dependencies on IEU_UWQM_ITEMS

Line 60: from ieu_uwqm_items

56: WHERE incident_status_id = p_sr_rec.status_id;
57:
58: cursor sel_sr_wi_csr is
59: select work_item_id
60: from ieu_uwqm_items
61: where WORKITEM_OBJ_CODE = 'SR'
62: and WORKITEM_PK_ID = p_incident_id;
63:
64: begin

Line 325: from ieu_uwqm_items

321: l_sr_activation_status VARCHAR2(3) := 'N' ;
322:
323: cursor sel_sr_wi_csr is
324: select work_item_id
325: from ieu_uwqm_items
326: where WORKITEM_OBJ_CODE = 'SR'
327: and WORKITEM_PK_ID = p_incident_id;
328:
329: cursor sel_status_flags_csr(l_status_id IN NUMBER) IS