APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on CS_INCIDENTS_ALL_B

Line 204: FROM cs_incidents_all_B sr,

200: AND nvl(task.open_flag,'Y') = 'Y';
201:
202: CURSOR c_sr_status IS
203: SELECT status.close_flag
204: FROM cs_incidents_all_B sr,
205: cs_incident_statuses_b status
206: WHERE sr.incident_id = p_service_request_id
207: AND sr.incident_status_id = status.incident_status_id
208: AND status.close_flag = 'Y';

Line 365: FROM cs_incidents_all_b

361: CS_EAM_ORDERS_EXIST exception;
362:
363: CURSOR c_status(c_request_id number) IS
364: SELECT incident_status_id
365: FROM cs_incidents_all_b
366: WHERE incident_id = c_request_id;
367:
368: CURSOR c_charge_lines IS
369: SELECT incident_id

Line 407: FROM cs_incidents_all_b

403: and uer.related_ue_id = ue.unit_effectivity_id
404: and sr_ue.cs_incident_id = p_service_request_id;
405: CURSOR c_obj_ver_num IS
406: Select object_version_number
407: FROM cs_incidents_all_b
408: WHERE incident_id = p_service_request_id;
409:
410:
411: /* ROOPA - 12/02/2003 - Begin*/

Line 416: cs_incidents_all_b inc

412: /* This block of code takes care of the exception path for upward status propagation */
413: CURSOR l_cs_sr_get_empid_csr IS
414: SELECT inc.incident_number, emp.source_id
415: FROM jtf_rs_resource_extns emp ,
416: cs_incidents_all_b inc
417: WHERE emp.resource_id = inc.incident_owner_id
418: AND inc.incident_id = p_service_request_id;
419:
420: l_subject_owner_id NUMBER;