APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENTS_V

Line 957: FROM CS_INCIDENTS_V

953: CURSOR get_request_dtls_csr(p_request_id IN NUMBER,
954: p_request_number IN VARCHAR2,
955: p_object_version_number IN NUMBER) IS
956: /*SELECT incident_id, incident_status_id, closed_flag, customer_product_id, expected_resolution_date
957: FROM CS_INCIDENTS_V
958: WHERE INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
959: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
960: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
961:

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

976: SELECT 'x' from AHL_VISIT_TASKS_B
977: where UNIT_EFFECTIVITY_ID = p_ue_id;
978:
979: l_sr_status_id NUMBER := NULL;
980: l_closed_flag CS_INCIDENTS_V.CLOSED_FLAG%TYPE := NULL;
981: l_dummy VARCHAR2(1);
982:
983: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Associated_Request';
984: