DBA Data[Home] [Help]

APPS.CN_TSR_PVT dependencies on CN_SRP_ROLE_DTLS

Line 130: cn_srp_role_dtls srd,

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,
131: jtf_rs_group_usages u
132: WHERE jg.group_id = jgm.group_id
133: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')
134: and jrs.resource_id = jgm.resource_id

Line 163: cn_srp_role_dtls srd,

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
166: and rr.role_relate_id = srd.srp_role_id
167: and rr.role_resource_type = 'RS_INDIVIDUAL'