APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_ROLES

Line 23: cn_roles role,

19: FROM cn_srp_plan_assigns assign,
20: fnd_user u,
21: cn_salesreps rep,
22: cn_comp_plans plan,
23: cn_roles role,
24: cn_period_statuses ps,
25: jtf_rs_resource_extns re
26: WHERE re.user_id = fnd_global.user_id
27: AND re.resource_id = rep.resource_id

Line 53: cn_roles role,

49: FROM cn_srp_plan_assigns assign,
50: fnd_user u,
51: cn_salesreps rep,
52: cn_comp_plans plan,
53: cn_roles role,
54: cn_period_statuses ps
55: WHERE u.user_id = p_user_id
56: AND rep.assigned_to_user_id = u.user_id
57: AND assign.salesrep_id = rep.salesrep_id

Line 81: cn_roles role,

77: FROM cn_srp_plan_assigns assign,
78: fnd_user u,
79: cn_salesreps rep,
80: cn_comp_plans plan,
81: cn_roles role,
82: cn_period_statuses ps
83: WHERE rep.assigned_to_user_id = u.user_id (+)
84: AND assign.salesrep_id = rep.salesrep_id
85: AND ps.period_id = p_period_id