DBA Data[Home] [Help]

APPS.AHL_UMP_UTIL_PKG dependencies on CS_INCIDENT_LINKS

Line 488: FROM cs_incident_links link, cs_incidents_all_vl inc

484:
485: CURSOR get_SR_details_csr (p_unit_effectivity_id IN NUMBER,
486: p_cs_link_id IN NUMBER) IS
487: SELECT inc.incident_number, inc.incident_id
488: FROM cs_incident_links link, cs_incidents_all_vl inc
489: WHERE link.subject_id = inc.incident_id
490: AND subject_type = 'SR'
491: AND link_type_id = p_cs_link_id
492: AND object_type = 'AHL_UMP_EFF'