APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_ROLES_B

Line 623: FROM jtf_rs_roles_b c,

619: EXIT WHEN l_mgr = 1;
620: BEGIN
621: SELECT '1'
622: INTO l_mgr
623: FROM jtf_rs_roles_b c,
624: jtf_rs_role_relations b,
625: jtf_rs_group_members a
626: WHERE a.group_id = parent_grp_rec.parent_group_id
627: AND a.resource_id = l_resource_id

Line 652: FROM jtf_rs_roles_b c,

648: -- Check if user is active Manager/Admin of group being queried
649: BEGIN
650: SELECT '2'
651: INTO l_mgr
652: FROM jtf_rs_roles_b c,
653: jtf_rs_role_relations b,
654: jtf_rs_group_members a
655: WHERE a.group_id = p_group_id
656: AND a.resource_id = l_resource_id