DBA Data[Home] [Help]

APPS.AHL_UMP_UTIL_PKG dependencies on CS_INCIDENTS_ALL_VL

Line 431: FROM cs_incident_links link, cs_incidents_all_vl inc

427:
428: CURSOR get_SR_details_csr (p_unit_effectivity_id IN NUMBER,
429: p_cs_link_id IN NUMBER) IS
430: SELECT inc.incident_number, inc.incident_id
431: FROM cs_incident_links link, cs_incidents_all_vl inc
432: WHERE link.subject_id = inc.incident_id
433: AND subject_type = 'SR'
434: AND link_type_id = p_cs_link_id
435: AND object_type = 'AHL_UMP_EFF'