APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENTS_ALL_B

Line 224: FROM cs_incidents_all_b

220: -- Validate Incident ID
221: CURSOR validate_incident_id ( c_request_id in NUMBER )
222: IS
223: SELECT incident_id
224: FROM cs_incidents_all_b
225: WHERE incident_id = c_request_id;
226:
227: -- Validate Item Instance
228: CURSOR validate_instance ( c_instance_id in NUMBER)

Line 963: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC

959: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
960: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
961:
962: SELECT INC.incident_id, INC.incident_status_id, NVL(STATUS.CLOSE_FLAG, 'N') closed_flag, INC.customer_product_id, INC.expected_resolution_date
963: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC
964: WHERE INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
965: AND INC.INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
966: AND INC.INCIDENT_NUMBER like NVL(p_request_number, '%')
967: AND INC.OBJECT_VERSION_NUMBER = p_object_version_number;