APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_GROUPS_VL

Line 21: from jtf_rs_groups_vl

17: ) IS
18:
19: cursor c_grp_name (l_group_id jtf_rs_groups_b.group_id%type) is
20: select group_name
21: from jtf_rs_groups_vl
22: where group_id = l_group_id;
23:
24: cursor c_grp_mem (l_group_id jtf_rs_groups_b.group_id%type) is
25: select resource_id

Line 38: l_group_name jtf_rs_groups_vl.group_name%type;

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:
42: cursor c_res_hier (l_resource_id jtf_rs_resource_extns.resource_id%type) is