3435: IS
3436: -- cursor to get the lines for a given eco: bug 5414834
3437: CURSOR lines_for_eco( p_change_id NUMBER) IS
3438: SELECT status_code ,sequence_number , name
3439: FROM eng_change_lines_vl
3440: WHERE eng_change_lines_vl.change_id = p_change_id
3441: and sequence_number<> -1;
3442:
3443:
3436: -- cursor to get the lines for a given eco: bug 5414834
3437: CURSOR lines_for_eco( p_change_id NUMBER) IS
3438: SELECT status_code ,sequence_number , name
3439: FROM eng_change_lines_vl
3440: WHERE eng_change_lines_vl.change_id = p_change_id
3441: and sequence_number<> -1;
3442:
3443:
3444: BEGIN