DBA Data[Home] [Help]

APPS.CN_MARK_EVENTS_PKG dependencies on CN_RT_QUOTA_ASGNS_ALL

Line 3171: FROM cn_rate_sch_dims_all rt, cn_rt_quota_asgns_all rt_assign

3167: , spq.quota_id
3168: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel
3169: WHERE spq.quota_id IN(
3170: SELECT rt_assign.quota_id
3171: FROM cn_rate_sch_dims_all rt, cn_rt_quota_asgns_all rt_assign
3172: WHERE rt.rate_dimension_id = p_object_id
3173: AND rt_assign.rate_schedule_id = rt.rate_schedule_id)
3174: AND intel.salesrep_id = spq.salesrep_id
3175: AND intel.period_id = spq.period_id