APPS.BIV_SR_DETAILS_PKG dependencies on JTF_RS_GROUPS_B

Line 192: l_group_id jtf_rs_groups_b.group_id % type;

188: );
189:
190: /**End of appsperf fix for bug#5029442**/
191:
192: l_group_id jtf_rs_groups_b.group_id % type;
193: begin
194: delete from biv_resource_groups;
195: open c_parent_groups;
196: loop

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