APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENTS_ALL_B

Line 216: FROM cs_incidents_all_b

212: -- Validate Incident ID
213: CURSOR validate_incident_id ( c_request_id in NUMBER )
214: IS
215: SELECT incident_id
216: FROM cs_incidents_all_b
217: WHERE incident_id = c_request_id;
218:
219: -- Validate Item Instance
220: CURSOR validate_instance ( c_instance_id in NUMBER)

Line 929: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC

925: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
926: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
927:
928: SELECT INC.incident_id, INC.incident_status_id, NVL(STATUS.CLOSE_FLAG, 'N') closed_flag, INC.customer_product_id, INC.expected_resolution_date
929: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC
930: WHERE INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
931: AND INC.INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
932: AND INC.INCIDENT_NUMBER like NVL(p_request_number, '%')
933: AND INC.OBJECT_VERSION_NUMBER = p_object_version_number;