APPS.AR_RAAPI_UTIL dependencies on JTF_RS_GROUPS_B

Line 548: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp,

544:
545: /* BEGIN bug 3067675 */
546: CURSOR c_salesgroup_id (p_salesgroup_id NUMBER) IS
547: SELECT grp.group_id group_id
548: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp,
549: jtf_rs_salesreps srp, jtf_rs_group_usages usg,
550: jtf_rs_role_relations rrl
551: WHERE srp.resource_id = mem.resource_id
552: AND mem.group_id = grp.group_id

Line 567: FROM jtf_rs_groups_b

563: AND l_group_end_date BETWEEN grp.start_date_active AND nvl(grp.end_date_active, to_date('01/01/4713','MM/DD/RRRR'))
564: AND grp.group_id = p_salesgroup_id
565: UNION ALL
566: SELECT group_id
567: FROM jtf_rs_groups_b
568: WHERE group_id = -1
569: AND group_id = p_salesgroup_id;
570: /* END bug 3067675 */
571: