APPS.JTF_RS_GROUP_RELATE_VUHK dependencies on JTF_RS_GROUP_USAGES

Line 67: FROM jtf_rs_group_usages u,

63: -- cursor to get the usage code of the group identified by p_group_id
64: -- Do we need to make sure that the related group is also used by OSC
65: CURSOR group_info IS
66: SELECT r.start_date_active, r.end_date_active, r.group_id
67: FROM jtf_rs_group_usages u,
68: jtf_rs_grp_relations r
69: WHERE r.group_relate_id = p_group_relate_id
70: AND u.group_id = r.group_id AND u.usage = 'SALES_COMP';
71:

Line 362: FROM jtf_rs_group_usages u,

358: -- cursor to get the usage code of the group identified by p_group_id
359: -- Do we need to make sure that the related group is also used by OSC
360: CURSOR group_info IS
361: SELECT r.start_date_active, r.end_date_active, r.group_id
362: FROM jtf_rs_group_usages u,
363: jtf_rs_grp_relations r
364: WHERE r.group_relate_id = p_group_relate_id
365: AND u.group_id = r.group_id AND u.usage = 'SALES_COMP';
366:

Line 588: FROM jtf_rs_group_usages

584: -- cursor to get the usage code of the group identified by p_group_id.
585: -- Do we need to make sure that the related group is also used by OSC ???
586: CURSOR usage IS
587: SELECT 1
588: FROM jtf_rs_group_usages
589: WHERE group_id = p_group_id AND usage = 'SALES_COMP';
590:
591: -- cursor to get the name of the group identified by p_group_id
592: CURSOR group_name IS