APPS.BIV_SR_DETAILS_PKG dependencies on JTF_RS_GROUP_USAGES

Line 178: select/*+index_ffs(grp_out jtf_rs_grp_relations_n1) index_ffs(usg JTF_RS_GROUP_USAGES_U2)*/ distinct related_group_id

174: This cursor will give you all the groups which are at top level
175: ***************************/
176: /*****Hints added and "not exists" replaced with "not in" as part of appsperf bug fix (bug#5029442)********/
177: cursor c_parent_groups is
178: select/*+index_ffs(grp_out jtf_rs_grp_relations_n1) index_ffs(usg JTF_RS_GROUP_USAGES_U2)*/ distinct related_group_id
179: from jtf_rs_grp_relations grp_out,
180: jtf_rs_group_usages usg
181: where relation_type = 'PARENT_GROUP'
182: and grp_out.related_group_id = usg.group_id

Line 180: jtf_rs_group_usages usg

176: /*****Hints added and "not exists" replaced with "not in" as part of appsperf bug fix (bug#5029442)********/
177: cursor c_parent_groups is
178: select/*+index_ffs(grp_out jtf_rs_grp_relations_n1) index_ffs(usg JTF_RS_GROUP_USAGES_U2)*/ distinct related_group_id
179: from jtf_rs_grp_relations grp_out,
180: jtf_rs_group_usages usg
181: where relation_type = 'PARENT_GROUP'
182: and grp_out.related_group_id = usg.group_id
183: and usg.usage in ( 'METRICS', 'SUPPORT')
184: and grp_out.related_group_id

Line 222: set usage = (select usage from jtf_rs_group_usages b

218: -- dbms_output.put_line('Error Text:'|| sqlerrm);
219: end;
220: end loop;
221: update biv_resource_groups a
222: set usage = (select usage from jtf_rs_group_usages b
223: where a.group_id = b.group_id
224: and usage in ('METRICS', 'SUPPORT')
225: and rownum = 1);
226: close c_parent_groups;

Line 230: from jtf_rs_groups_b a, jtf_rs_group_usages b

226: close c_parent_groups;
227: commit;
228: insert into biv_resource_groups ( group_id, group_level, usage)
229: select a.group_id, 1, b.usage
230: from jtf_rs_groups_b a, jtf_rs_group_usages b
231: where a.group_id = b.group_id
232: and b.usage in ('SUPPORT', 'METRICS')
233: and not exists ( select 1
234: from biv_resource_groups r