APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_GROUPS_B

Line 19: cursor c_grp_name (l_group_id jtf_rs_groups_b.group_id%type) is

15: X_RESOURCE_ID IN NUMBER,
16: X_GROUP_ID IN NUMBER
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:

Line 24: cursor c_grp_mem (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
26: from jtf_rs_group_members
27: where group_id = l_group_id;
28:

Line 33: l_group_id jtf_rs_groups_b.group_id%type := x_group_id;

29: c_grp_mem_rec c_grp_mem%rowtype;
30:
31: l_report_type varchar2(30) := x_report_type;
32: l_resource_id jtf_rs_resource_extns.resource_id%type := x_resource_id;
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;