[Home] [Help]
663: ---Newly added code for performance improvement
664: PROCEDURE get_parts_status IS
665: CURSOR c_parts_status IS
666: SELECT task_id
667: FROM csp_requirement_headers
668: WHERE task_id in (select DISTINCT column_value
669: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))
670: where column_value <> 0);
671: i BINARY_INTEGER := 0;