APPS.AHL_UMP_UNITMAINT_PVT dependencies on CS_INCIDENTS_ALL_B

Line 1561: FROM cs_incident_links CLK, CS_INCIDENTS_ALL_B CS

1557:
1558: CURSOR l_servq_num_csr (p_ue_id IN NUMBER, p_object_type IN VARCHAR2,
1559: p_subject_type IN VARCHAR2, p_link_type_id IN NUMBER) IS
1560: SELECT CS.incident_number
1561: FROM cs_incident_links CLK, CS_INCIDENTS_ALL_B CS
1562: WHERE CS.incident_id = CLK.subject_id
1563: AND CLK.object_id = p_ue_id
1564: AND CLK.object_type = p_object_type
1565: AND CLK.subject_type = p_subject_type

Line 1608: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;

1604:
1605: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1606: l_err_due_date DATE;
1607: l_err_title ahl_mr_headers_b.title%TYPE;
1608: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1609: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;
1610: -- added to validate visit status.
1611: l_visit_status VARCHAR2(100);
1612: --pdoki added for ER 9583373