APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 98: FROM cn_srp_plan_assigns_all spa,

94: RETURN BOOLEAN IS
95:
96: CURSOR l_active_plan_csr IS
97: SELECT 1
98: FROM cn_srp_plan_assigns_all spa,
99: cn_comp_plans_all plan
100: WHERE spa.salesrep_id = p_salesrep_id
101: AND spa.org_id = p_org_id
102: AND ((spa.end_date IS NOT NULL