DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on CS_INCIDENT_LINKS

Line 1370: FROM cs_incident_links CLK, CS_INCIDENTS_ALL_B CS

1366:
1367: CURSOR l_servq_num_csr (p_ue_id IN NUMBER, p_object_type IN VARCHAR2,
1368: p_subject_type IN VARCHAR2, p_link_type_id IN NUMBER) IS
1369: SELECT CS.incident_number
1370: FROM cs_incident_links CLK, CS_INCIDENTS_ALL_B CS
1371: WHERE CS.incident_id = CLK.subject_id
1372: AND CLK.object_id = p_ue_id
1373: AND CLK.object_type = p_object_type
1374: AND CLK.subject_type = p_subject_type