APPS.JTF_RS_DEFAULT_GROUPS_CONC_PUB dependencies on JTF_RS_ROLES_B

Line 236: ,jtf_rs_roles_b rol

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
238: ,jtf_rs_resource_extns res
239: WHERE rrl.role_resource_type = 'RS_GROUP_MEMBER'
240: AND rrl.delete_flag = 'N'

Line 301: ,jtf_rs_roles_b rol

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'
305: AND rrl.role_id = rol.role_id