APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENTS_V

Line 923: FROM CS_INCIDENTS_V

919: CURSOR get_request_dtls_csr(p_request_id IN NUMBER,
920: p_request_number IN VARCHAR2,
921: p_object_version_number IN NUMBER) IS
922: /*SELECT incident_id, incident_status_id, closed_flag, customer_product_id, expected_resolution_date
923: FROM CS_INCIDENTS_V
924: WHERE INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
925: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
926: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
927:

Line 946: l_closed_flag CS_INCIDENTS_V.CLOSED_FLAG%TYPE := NULL;

942: SELECT 'x' from AHL_VISIT_TASKS_B
943: where UNIT_EFFECTIVITY_ID = p_ue_id;
944:
945: l_sr_status_id NUMBER := NULL;
946: l_closed_flag CS_INCIDENTS_V.CLOSED_FLAG%TYPE := NULL;
947: l_dummy VARCHAR2(1);
948:
949: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Associated_Request';
950: