DBA Data[Home] [Help]

APPS.CN_MARK_EVENTS_PKG dependencies on CN_RATE_SCH_DIMS_ALL

Line 3173: FROM cn_rate_sch_dims_all rt, cn_rt_quota_asgns_all rt_assign

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