292: AND net.transition_type <> 3)
293: ORDER BY from_seq_num;
294:
295: CURSOR check_nwk_links_cur IS
296: SELECT null FROM DUAL
297: WHERE exists
298: ( SELECT null FROM bom_operation_networks_v bonv
299: WHERE bonv.routing_sequence_id = p_routing_sequence_id
300: AND bonv.operation_type = p_operation_type
495: AND net.transition_type <> 3)
496: ORDER BY from_seq_num;
497:
498: CURSOR check_nwk_links_cur IS
499: SELECT null FROM DUAL
500: WHERE exists
501: ( SELECT null FROM bom_operation_networks_v bonv
502: WHERE bonv.routing_sequence_id = p_routing_sequence_id
503: AND bonv.operation_type = p_operation_type