APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on CS_INCIDENTS_ALL_B

Line 201: FROM cs_incidents_all_B sr,

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

Line 363: FROM cs_incidents_all_b

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

Line 405: FROM cs_incidents_all_b

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

Line 414: cs_incidents_all_b inc

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