DBA Data[Home] [Help]

APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_PRODUCTS_V

Line 155: cursor c_plat_name (l_platform_id jtf_rs_products_v.product_name%type) is

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:

Line 160: cursor c_prod_name (l_product_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:
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:

Line 162: from jtf_rs_products_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:
165: cursor c_cat_name (l_category_id jtf_rs_item_categories_v.category_name%type) is
166: select category_name