DBA Data[Home] [Help]

APPS.CN_MARK_EVENTS_PKG dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 604: FROM cn_srp_plan_assigns_all

600: SELECT quota_id
601: FROM cn_srp_quota_assigns_all
602: WHERE srp_plan_assign_id IN(
603: SELECT srp_plan_assign_id
604: FROM cn_srp_plan_assigns_all
605: WHERE salesrep_id = p_salesrep_id
606: AND org_id = p_org_id))
607: AND (
608: q.incremental_type = 'N'

Line 3753: FROM cn_srp_plan_assigns_all spa

3749: DISTINCT spa.salesrep_id
3750: , acc.period_id
3751: , acc.start_date
3752: , acc.end_date
3753: FROM cn_srp_plan_assigns_all spa
3754: , cn_srp_intel_periods_all intel
3755: , cn_period_statuses_all acc
3756: WHERE spa.comp_plan_id = p_object_id -- comp_plan_id
3757: AND acc.period_id BETWEEN l_start_period_id AND l_end_period_id