APPS.JTF_RS_GROUP_REPORT_PUB dependencies on JTF_RS_GROUP_USAGES

Line 255: select /*+ INDEX(usg jtf_rs_group_usages_n1) */ group_id

251: l_no_of_days number;
252:
253: cursor c_grp_usage
254: is
255: select /*+ INDEX(usg jtf_rs_group_usages_n1) */ group_id
256: from jtf_rs_group_usages usg
257: where usg.usage = p_usage
258: and not exists (select group_id
259: from jtf_rs_grp_relations rel

Line 256: from jtf_rs_group_usages usg

252:
253: cursor c_grp_usage
254: is
255: select /*+ INDEX(usg jtf_rs_group_usages_n1) */ group_id
256: from jtf_rs_group_usages usg
257: where usg.usage = p_usage
258: and not exists (select group_id
259: from jtf_rs_grp_relations rel
260: where rel.group_id = usg.group_id

Line 265: select /*+ INDEX(usg jtf_rs_group_usages_n1) */ group_id

261: and nvl(delete_flag, 'N') <> 'Y') ;
262:
263: cursor c_grp_usage2
264: is
265: select /*+ INDEX(usg jtf_rs_group_usages_n1) */ group_id
266: from jtf_rs_group_usages usg
267: where usg.usage = p_usage
268: and usg.group_id = p_group_id;
269:

Line 266: from jtf_rs_group_usages usg

262:
263: cursor c_grp_usage2
264: is
265: select /*+ INDEX(usg jtf_rs_group_usages_n1) */ group_id
266: from jtf_rs_group_usages usg
267: where usg.usage = p_usage
268: and usg.group_id = p_group_id;
269:
270: r_grp_usage c_grp_usage%rowtype;

Line 1211: from jtf_rs_group_usages usg

1207: cursor c_check_usage(l_group_id number,
1208: l_usage varchar2)
1209: is
1210: select usg.usage
1211: from jtf_rs_group_usages usg
1212: where usg.usage = l_usage
1213: and usg.group_id = l_group_id;
1214:
1215: