APPS.JTF_RS_GROUP_REPORT_PUB dependencies on JTF_RS_GRP_RELATIONS

Line 259: from jtf_rs_grp_relations rel

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
261: and nvl(delete_flag, 'N') <> 'Y') ;
262:
263: cursor c_grp_usage2

Line 902: FROM jtf_rs_grp_relations rel

898: trunc(least(nvl(rel.end_date_active, p_least_end_date),
899: nvl(p_least_end_date, rel.end_date_active))) least_end_date,
900: start_date_active relation_start_date,
901: end_date_active relation_end_date
902: FROM jtf_rs_grp_relations rel
903: WHERE relation_type = 'PARENT_GROUP'
904: AND rel.related_group_id = p_group_id
905: AND NVL(rel.delete_flag, 'N') <> 'Y'
906: /*