APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_ITEM_CATEGORIES_V

Line 165: cursor c_cat_name (l_category_id jtf_rs_item_categories_v.category_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
167: from jtf_rs_item_categories_v
168: where category_id = l_category_id;
169:

Line 167: from jtf_rs_item_categories_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
167: from jtf_rs_item_categories_v
168: where category_id = l_category_id;
169:
170: cursor c_comp_name (l_component_id jtf_rs_components_v.component_name%type) is
171: select component_name

Line 182: l_category_name jtf_rs_item_categories_v.category_name%type := null;

178: l_product_id jtf_rs_resource_skills.product_id%type;
179:
180: l_component_id jtf_rs_resource_skills.component_id%type := null;
181: l_category_id jtf_rs_resource_skills.category_id%type := null;
182: l_category_name jtf_rs_item_categories_v.category_name%type := null;
183: l_component_name jtf_rs_components_v.component_name%type := null;
184:
185: l_skill_type fnd_lookups.meaning%type := null;
186: l_skill_name varchar2(242) := null;