3008: IS
3009: -- cursor to get the lines for a given eco: bug 5414834
3010: CURSOR lines_for_eco( p_change_id NUMBER) IS
3011: SELECT status_code ,sequence_number , name
3012: FROM eng_change_lines_vl
3013: WHERE eng_change_lines_vl.change_id = p_change_id
3014: and sequence_number<> -1;
3015:
3016:
3009: -- cursor to get the lines for a given eco: bug 5414834
3010: CURSOR lines_for_eco( p_change_id NUMBER) IS
3011: SELECT status_code ,sequence_number , name
3012: FROM eng_change_lines_vl
3013: WHERE eng_change_lines_vl.change_id = p_change_id
3014: and sequence_number<> -1;
3015:
3016:
3017: BEGIN