APPS.CN_SFP_GROUP_UTIL_PVT dependencies on JTF_RS_GROUPS_DENORM

Line 60: SELECT group_id,parent_group_id from jtf_rs_groups_denorm

56: l_selected_groups grpnum_tbl_type;
57: l_found boolean := false;
58: l_out_counter NUMBER := 0;
59: CURSOR groups_cur(p_comp_group_id NUMBER) IS
60: SELECT group_id,parent_group_id from jtf_rs_groups_denorm
61: where group_id = p_comp_group_id and parent_group_id <> p_comp_group_id;
62: BEGIN
63: l_selected_groups := p_selected_groups;
64: IF (p_selected_groups.COUNT > 0) THEN

Line 138: from jtf_rs_groups_denorm rgd,jtf_rs_group_usages rgu,jtf_rs_groups_vl rg

134: rg.group_name,
135: rgd.parent_group_id,
136: rgd.start_date_active,
137: rgd.end_date_active
138: from jtf_rs_groups_denorm rgd,jtf_rs_group_usages rgu,jtf_rs_groups_vl rg
139: where
140: rgd.group_id = rgu.group_id
141: and rg.group_id = rgu.group_id
142: and rg.group_id = rgd.group_id