APPS.AHL_UTILITY_PVT dependencies on CSI_II_RELATIONSHIPS

Line 623: FROM csi_ii_relationships

619: l_unit_name VARCHAR2(80);
620: l_instance_id NUMBER;
621: CURSOR get_uc_instance_id IS
622: SELECT object_id
623: FROM csi_ii_relationships
624: WHERE object_id IN (SELECT csi_item_instance_id
625: FROM ahl_unit_config_headers
626: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
627: START WITH subject_id = p_instance_id