APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENT_STATUSES_B

Line 28: -- column of CS_INCIDENT_STATUSES_B is obsoleted per SR Team (Thomas Alex)

24: G_UMP_MR_TERMINATE_STATUS CONSTANT VARCHAR2(30) := 'MR-TERMINATE';
25:
26: -- SR Statuses
27: --JR: Modified on 10/29/2003: Using Status Id instead of Code since STATUS_CODE
28: -- column of CS_INCIDENT_STATUSES_B is obsoleted per SR Team (Thomas Alex)
29: G_SR_PLANNED_STATUS_ID CONSTANT NUMBER := 52;
30:
31: -- Operation Codes
32: G_OPR_CREATE CONSTANT VARCHAR2(1) := 'C';

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;