151: select problem_name
152: from jtf_rs_problem_codes_v
153: where problem_code = l_problem_code;
154:
155: cursor c_plat_name (l_platform_id jtf_rs_products_v.product_name%type) is
156: select platform_name
157: from jtf_rs_platforms_v
158: where platform_id = l_platform_id;
159:
156: select platform_name
157: from jtf_rs_platforms_v
158: where platform_id = l_platform_id;
159:
160: cursor c_prod_name (l_product_id jtf_rs_products_v.product_name%type) is
161: select product_name
162: from jtf_rs_products_v
163: where product_id = l_product_id;
164:
158: where platform_id = l_platform_id;
159:
160: cursor c_prod_name (l_product_id jtf_rs_products_v.product_name%type) is
161: select product_name
162: from jtf_rs_products_v
163: where product_id = l_product_id;
164:
165: cursor c_cat_name (l_category_id jtf_rs_item_categories_v.category_name%type) is
166: select category_name