83: WHERE
84: NOT EXISTS (
85: SELECT 1
86: from jtf_rs_groups_vl jg,
87: jtf_rs_role_relations jrr,
88: jtf_rs_salesreps jrs,
89: jtf_rs_roles_b jr,
90: jtf_rs_group_mbr_role_vl jgm,
91: jtf_rs_group_usages u
122: WHERE
123: EXISTS (
124: SELECT 1
125: from jtf_rs_groups_vl jg,
126: jtf_rs_role_relations jrr,
127: jtf_rs_salesreps jrs,
128: jtf_rs_roles_b jr,
129: jtf_rs_group_mbr_role_vl jgm,
130: cn_srp_role_dtls srd,
157: /*
158: AND NOT EXISTS --- Check this
159: (
160: SELECT s.salesrep_id
161: from jtf_rs_role_relations rr,
162: jtf_rs_salesreps s,
163: cn_srp_role_dtls srd,
164: jtf_rs_roles_b r
165: WHERE rr.role_resource_id = s.resource_id