APPS.AHL_VWP_RULES_PVT dependencies on CSI_II_RELATIONSHIPS

Line 114: FROM csi_ii_relationships

110: FROM ahl_visits_b
111: WHERE visit_id = p_visit_id;
112: CURSOR check_instance_in_tree(c_top_instance_id NUMBER, c_instance_id NUMBER) IS
113: SELECT subject_id
114: FROM csi_ii_relationships
115: WHERE subject_id = c_instance_id
116: START WITH object_id = c_top_instance_id
117: AND relationship_type_code = 'COMPONENT-OF'
118: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)