APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_SRP_PLAN_ASSIGNS

Line 19: FROM cn_srp_plan_assigns assign,

15: u.user_name analyst_name,
16: role.name role_name,
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,

Line 49: FROM cn_srp_plan_assigns assign,

45: u.user_name analyst_name,
46: role.name role_name,
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,

Line 77: FROM cn_srp_plan_assigns assign,

73: u.user_name analyst_name,
74: role.name role_name,
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,

Line 106: from cn_srp_periods p, cn_srp_plan_assigns spa

102: (nvl(balance28_bbd,0) - nvl(balance28_bbc,0))),0) begin_balance,
103: nvl(sum((nvl(balance2_dtd, 0) - nvl(balance2_ctd, 0)) +
104: (nvl(balance10_dtd,0) - nvl(balance10_ctd,0))),0) earnminuspay,
105: nvl(sum((nvl(balance28_dtd,0) - nvl(balance28_ctd,0))),0) draw
106: from cn_srp_periods p, cn_srp_plan_assigns spa
107: where spa.srp_plan_assign_id = l_srp_plan_assign_id
108: and p.salesrep_id = spa.salesrep_id
109: and p.credit_type_id = p_credit_type_id
110: and p.role_id = spa.role_id