APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_COMPONENTS_V

Line 170: cursor c_comp_name (l_component_id jtf_rs_components_v.component_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
172: from jtf_rs_components_v
173: where component_id = l_component_id;
174:

Line 172: from jtf_rs_components_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
172: from jtf_rs_components_v
173: where component_id = l_component_id;
174:
175: l_subcategory jtf_rs_resource_skills.subcategory%type;
176: l_problem_code jtf_rs_resource_skills.problem_code%type;

Line 183: l_component_name jtf_rs_components_v.component_name%type := null;

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;
187: l_skill_level jtf_rs_skill_levels_vl.level_name%type := null;