DBA Data[Home] [Help]

APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_COMP_PLANS_ALL

Line 99: cn_comp_plans_all plan

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
103: AND p_end_date BETWEEN spa.start_date AND spa.end_date)