APPS.JTF_RS_DEFAULT_GROUPS_CONC_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 233: FROM jtf_rs_role_relations rrl

229: ,nvl(rrl.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR')) end_date
230: ,rrl.role_id
231: ,rol.role_type_code
232: ,COUNT(den.group_id) denorm_count
233: FROM jtf_rs_role_relations rrl
234: ,jtf_rs_group_members mem
235: ,jtf_rs_group_usages usg
236: ,jtf_rs_roles_b rol
237: ,jtf_rs_groups_denorm den

Line 300: FROM jtf_rs_role_relations rrl

296: 99 role_priority,
297: TO_DATE('01/01/1900','MM/DD/RRRR') START_DATE,
298: TO_DATE('12/31/4712','MM/DD/RRRR') END_DATE,
299: 99999999 denorm_count
300: FROM jtf_rs_role_relations rrl
301: ,jtf_rs_roles_b rol
302: ,jtf_rs_resource_extns res
303: WHERE rrl.role_resource_type = 'RS_INDIVIDUAL'
304: AND rrl.delete_flag = 'N'