APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_SALESREPS

Line 21: cn_salesreps rep,

17: plan.name comp_plan_name,
18: assign.srp_plan_assign_id srp_plan_assign_id
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

Line 51: cn_salesreps rep,

47: plan.name comp_plan_name,
48: assign.srp_plan_assign_id srp_plan_assign_id
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

Line 79: cn_salesreps rep,

75: plan.name comp_plan_name,
76: assign.srp_plan_assign_id srp_plan_assign_id
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 (+)