APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_ROLES_B

Line 611: FROM jtf_rs_roles_b c,

607: EXIT WHEN l_mgr = 1;
608: BEGIN
609: SELECT '1'
610: INTO l_mgr
611: FROM jtf_rs_roles_b c,
612: jtf_rs_role_relations b,
613: jtf_rs_group_members a
614: WHERE a.group_id = parent_grp_rec.parent_group_id
615: AND a.resource_id = l_resource_id

Line 640: FROM jtf_rs_roles_b c,

636: -- Check if user is active Manager/Admin of group being queried
637: BEGIN
638: SELECT '2'
639: INTO l_mgr
640: FROM jtf_rs_roles_b c,
641: jtf_rs_role_relations b,
642: jtf_rs_group_members a
643: WHERE a.group_id = p_group_id
644: AND a.resource_id = l_resource_id