APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_COMP_PLANS

Line 22: cn_comp_plans plan,

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
26: WHERE re.user_id = fnd_global.user_id

Line 52: cn_comp_plans plan,

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
56: AND rep.assigned_to_user_id = u.user_id

Line 80: cn_comp_plans plan,

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 (+)
84: AND assign.salesrep_id = rep.salesrep_id