[Home] [Help]
APPS.JTF_RS_SRP_GROUPS_CONC_PUB dependencies on JTF_RS_ROLE_RELATIONS
Line 228: FROM jtf_rs_role_relations rrl
224: ,nvl(rrl.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR')) end_date
225: ,rrl.role_id
226: ,rol.role_type_code
227: ,COUNT(den.group_id) denorm_count
228: FROM jtf_rs_role_relations rrl
229: ,jtf_rs_group_members mem
230: ,jtf_rs_salesreps srp
231: ,jtf_rs_group_usages usg
232: ,jtf_rs_roles_b rol