APPS.AHL_VWP_RULES_PVT dependencies on CS_INCIDENTS_ALL_B

Line 596: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT

592: -- yazhou 19Oct2005 Starts
593: -- Bug fix #4415024
594: IF p_service_id IS NOT NULL THEN
595: SELECT a.Incident_Id INTO x_service_id
596: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT
597: WHERE a.incident_type_id = cit.incident_type_id
598: AND cit.INCIDENT_SUBTYPE = 'INC'
599: AND cit.CMRO_FLAG = 'Y'
600: AND Incident_Id = p_service_id;

Line 603: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT

599: AND cit.CMRO_FLAG = 'Y'
600: AND Incident_Id = p_service_id;
601: ELSIF p_service_number IS NOT NULL THEN
602: SELECT a.Incident_Id INTO x_service_id
603: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT
604: WHERE a.incident_type_id = cit.incident_type_id
605: AND cit.INCIDENT_SUBTYPE = 'INC'
606: AND cit.CMRO_FLAG = 'Y'
607: AND Incident_Number = p_service_number;

Line 2551: SELECT customer_id FROM CS_INCIDENTS_ALL_B

2547:
2548: l_service_request_id NUMBER;
2549:
2550: CURSOR customer_id_csr(p_service_request_id IN NUMBER)IS
2551: SELECT customer_id FROM CS_INCIDENTS_ALL_B
2552: WHERE incident_id = p_service_request_id;
2553:
2554: l_customer_id NUMBER;
2555: