APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on FND_LOOKUPS

Line 136: from fnd_lookups fnl, jtf_rs_resource_skills rsk,

132:
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

Line 185: l_skill_type fnd_lookups.meaning%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;
188:
189: l_resource_number jtf_rs_resource_extns.resource_number%type;