APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_SKILL_LEVELS_VL

Line 137: jtf_rs_skill_levels_vl rsl

133: cursor c_res_skills is
134: select fnl.meaning skill_type, rsl.level_name, rsk.category_id, rsk.component_id,
135: rsk.subcategory, rsk.problem_code, rsk.product_id, rsk.platform_id
136: from fnd_lookups fnl, jtf_rs_resource_skills rsk,
137: jtf_rs_skill_levels_vl rsl
138: where lookup_type = 'JTF_RS_SKILL_CAT_TYPE'
139: and rsk.subcategory = lookup_code
140: and rsk.skill_level_id = rsl.skill_level_id
141: and rsk.resource_id = p_resource_id;

Line 187: l_skill_level jtf_rs_skill_levels_vl.level_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;
188:
189: l_resource_number jtf_rs_resource_extns.resource_number%type;
190: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
191: l_res_name jtf_rs_resource_extns_vl.resource_name%type;