DBA Data[Home] [Help]

APPS.CN_COMMISSION_CALC_PVT dependencies on CN_SRP_QUOTA_ASSIGNS

Line 121: cn_srp_quota_assigns csqa

117: cspa.comp_plan_id comp_plan_id,
118: cspa.start_date start_date,
119: nvl(cspa.end_date,p_date) end_date
120: FROM cn_srp_plan_assigns cspa,
121: cn_srp_quota_assigns csqa
122: WHERE cspa.salesrep_id = p_salesrep_id
123: AND p_date BETWEEN cspa.start_date AND nvl(cspa.end_date,p_date)
124: AND csqa.quota_id = p_quota_id
125: AND csqa.srp_plan_assign_id = cspa.srp_plan_assign_id;

Line 143: cn_srp_quota_assigns sqa,

139: , cci.name credit_type_name
140: , q.name quota_name
141: , qr.revenue_class_id
142: from cn_srp_plan_assigns spa,
143: cn_srp_quota_assigns sqa,
144: cn_quotas q,
145: cn_quota_rules qr,
146: cn_dim_hierarchies dh,
147: jtf_rs_salesreps jrs,