DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on CS_INCIDENT_LINKS

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