APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 37: l_res_mgr_name jtf_rs_resource_extns_vl.resource_name%type;

33: l_group_id jtf_rs_groups_b.group_id%type := x_group_id;
34:
35: m_resource_id jtf_rs_resource_extns.resource_id%type;
36: p_resource_id jtf_rs_resource_extns.resource_id%type;
37: l_res_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
38: l_group_name jtf_rs_groups_vl.group_name%type;
39: l_level_id number;
40: p_level number;
41:

Line 53: from jtf_rs_resource_extns_vl

49: c_res_hier_rec c_res_hier%rowtype;
50:
51: cursor c_res_mgr_name (l_resource_id jtf_rs_resource_extns.resource_id%type) is
52: select resource_name
53: from jtf_rs_resource_extns_vl
54: where resource_id = l_resource_id;
55:
56: BEGIN
57:

Line 147: from jtf_rs_resource_extns_vl

143: c_res_skills_rec c_res_skills%rowtype;
144:
145: cursor c_res_name is
146: select resource_name, resource_number
147: from jtf_rs_resource_extns_vl
148: where resource_id = p_resource_id;
149:
150: cursor c_prob_name (l_problem_code jtf_rs_problem_codes_v.problem_name%type) is
151: select problem_name

Line 190: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;

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;
192:
193: l_level number := p_level;
194: l_padder varchar(200):='';

Line 191: l_res_name jtf_rs_resource_extns_vl.resource_name%type;

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;
192:
193: l_level number := p_level;
194: l_padder varchar(200):='';
195: